=A1=TODAY()-90
=A1=TODAY()-60

and so on

--

HTH

Bob

"MGC Tibado" wrote in message
...
Ok, I was looking for a solution to this and have not found the correct
answer yet.

Cell A1 = 01/01/2010
Cell A2 = 05/16/2002

When Cell A1 is <= 30 days from the date in Cell A1 the fill or icon =
GRAY
When Cell A1 is = 30 days from the date in Cell A1 the fill or icon =
GREEN
When Cell A1 is = 60 days from the date in Cell A1 the fill or icon =
YELLOW
When Cell A1 is = 90 days from the date in Cell A1 the fill or icon = RED

And...
When Cell A2 is <= 30 days from the date in Cell A2 the fill or icon =
GRAY
When Cell A2 is = 30 days from the date in Cell A2 the fill or icon =
GREEN
When Cell A2 is = 60 days from the date in Cell A2 the fill or icon =
YELLOW
When Cell A2 is = 90 days from the date in Cell A2 the fill or icon = RED

So, you see what I need is a way to use the date in the cell (regardless
of
and unrelated to any other cells) to identify from that date when 30, 60,
and
90 days have gone by.

Thanks in advance...
MGC-BT