Hi,

I am trying to set 3 conditional formats on Cell A1:

A1 contains the date of when a vehicle inspection was conducted.
B1 Contains the Due date of the next inspection.

What I would like the cell to do is:
If todays date to the Due inspection date is over 2 months, the cell turns green.
If todays date to the Due inspection date is less than 2 months, but greater than 1 month, the cell turns amber.
If todays date to the due inspection date is less than 1 month, the cell turns red.

I have tried using the following formula which worked for the Green(=IF(DAYS360(TODAY(),F9)>60,TRUE,FALSE) & Red (=IF(DAYS360(TODAY(),F9)<30,TRUE,FALSE), but can't get it to work for Amber.

Any help greatfully received. (Excel 2003)

Thanks