Hi guys,

I am pulling my hair out over this and would be forever in your debt if solution provided.
I have an excel sheet 2003 with one column set with various future/current dates in format DD/MM/YYYY.
These dates contain due dates of annual returns and i'm looking for some formulas to identify when they are due. 3 conditions in total.
1. Cell to highlight YELLOW up to 30 days before cell date
2. Cell to highlight BLUE up to 28 days after cell date
3. Cell to highlight RED over 28 days after.

Can this be done?

Thanking you in advance.

Niall