S
Shapper
Hello,
I have a cell with a date and I would like to change the background
color to:
1 - Orange when Todays date is one month from the Cells date. Example:
Cell Date = 20-12-2010
Today = 08-12-2010
So it should become orange as Today it is within one month from
the Cell Date.
2 - Red when Todays date passes the Cells date.
How can I do this?
Thank You,
Miguel
I have a cell with a date and I would like to change the background
color to:
1 - Orange when Todays date is one month from the Cells date. Example:
Cell Date = 20-12-2010
Today = 08-12-2010
So it should become orange as Today it is within one month from
the Cell Date.
2 - Red when Todays date passes the Cells date.
How can I do this?
Thank You,
Miguel