I want to highlight dates that will be due in 30 days time. For example if an insurance is due for renewal I want my spreadsheet to show this record in Red and all other dates in differing colours. I can do normal formating using the conditional formating facility (on text and numbers) on the ribbon but how do I use the date function which does not seem to be there except through new rule. So in the attached example where the Caravan insurance is due within the next 4 weeks I would like this to be highlighted. The I would like those due within say 3 months to highlighted another colour and the rest say in a third colour. What formula do I need to achieve this please.DateTest.xlsx