I've set up a spreadsheet using conditional formats and dates for the first
time.

The conditions are as follows If Cell Value is greater than =TODAY(0)+60 -
condition green

If Cell Value is between =TODAY(0)+60 and TODAY(0)+20 - condition orange

If Cell Value is less =TODAY(0)+20 - condition red

The conditions work but DO NOT AUTOMATICALLY RE-CALCULATE and so DO NOT FLAG
CRITICAL DATES. Eg if a date when I entered it more than 60 days from the
current date it would of course be green. Two weeks later when I open the
spreadsheet and rthe date shown is now only 50 days from TODAY it still shows
green and not orange.

If I change the date and then change it back it will show orange but will
not automatically update the condition.

Is there anyway I can do this?

--
Thank you for your help

Marylin