You do this with Conditional Formatting.

Which version of Excel are you using? There are slight differences
between how you set this up in XL2007 and XL2003.

Hope this helps.

Pete

On Dec 8, 1:32*pm, Shapper wrote:
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