color code dates due

  • Thread starter Thread starter arcadia
  • Start date Start date
A

arcadia

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
 
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
 
Back
Top