Dates in Excel

[Closed]
Report
Posts
2
Registration date
Wednesday January 28, 2009
Status
Member
Last seen
February 1, 2009
-
Posts
2
Registration date
Wednesday January 28, 2009
Status
Member
Last seen
February 1, 2009
-
Hello,

Does anyone know if it is possible to program an excel date so that it will 'change colour' when the current/system date is within one (1) month of the date.

Thanks,

Paratrooper

2 replies

Posts
1
Registration date
Thursday January 29, 2009
Status
Member
Last seen
January 30, 2009

Yes, I did , let me try and remember how .
Using conditional formatting and a formla which becomes true when the current date + 30 becomes larger
than the date you have set.
Posts
2
Registration date
Wednesday January 28, 2009
Status
Member
Last seen
February 1, 2009

Hi,

Have you remembered the formula?

Thanks,

Paratrooper