Thread: Date Function
View Single Post
  #1   Report Post  
Dee
 
Posts: n/a
Default Date Function

I want to put conditional formatting into a cell where I want excel to change
the color of the date in the cell if it date is anywhere between today's date
and 2 months prior to today's date.

So if today's date is August 12th and the date in the cell is anywhere
between June 12th and August 12th the cell will change color. I am using
Excell 2003

Thanks very much for your help.

Best regards,

Dee