Select Cell F2, format the cell green, and then choose Format / CF with the Formula is option.

Use a formula

=AND(TODAY()=(A2+91), TODAY()<=(A2+182))

and format for amber, then add another condition, and use the formula is with

=AND(TODAY()=(A2+183), TODAY()<=(A2+365))

HTH,
Bernie
MS Excel MVP


"Custard Tart" wrote in message
...
Hi there,

I operate a spreadsheet which requires a traffic light system of RED,
AMBER and GREEN depending on the values within the spreadsheet. I'm
having some difficulties formatting the sheet correctly to allow the
appropriate cell to change colour.

For example:

Cell A2 contains the date on which the fault was reported. This is the
date which the formula refers to.

Cell F2 is a blank cell which needs to change colour based on how many
days it has been since the fault was reported. 90 days and under is
GREEN. 91 - 182 days are AMBER. 183 - 365 days are RED.

I have found several formulas which would not allow either the AMBER
or the RED to total up correctly. I have also found formulas which
would allow this but only in Cell A2 where the date is stored and not
F2 which is the blank cell with no value.

Can anyone help?

Thanks!