color code dates due
 

Hello,
I am new to excel and I need to work out a program for tracking dates.
I am looking at three dates to track. One is a first date for when a
review was done. I then need to track from this date, with say a later
date 2 months before the review is due, then when 1 month is due. I
would like that the cells were green for the first 10 months, then
turn yellow for a month, and then go red for the final month to warn
me it is due. As I say I am very new, if there is a complicated
formular I will need to know exactly what to do with it. TIA

color code dates due
 

Arcadia

Select the range of due dates and choose, Format,
Conditional format

condition 1 is less or equal to, the condition is
Now()+30 format the background to yellow. Click the Add
Button
Condition 2 Less or Equal to, Now()+335 Set the background
to Green
Condition 3 Greater or equal to Now() set the colour to
Red.

Regards
Peter
-----Original Message-----
Hello,
I am new to excel and I need to work out a program for
tracking dates.
I am looking at three dates to track. One is a first
date for when a
review was done. I then need to track from this date,
with say a later
date 2 months before the review is due, then when 1 month
is due. I
would like that the cells were green for the first 10
months, then
turn yellow for a month, and then go red for the final
month to warn
me it is due. As I say I am very new, if there is a
complicated
formular I will need to know exactly what to do with it.
TIA
.