View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
shapper shapper is offline
external usenet poster
 
Posts: 22
Default Change Cell Background

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