Dates in Excel

Closed
paratrooper
Posts
2
Registration date
Wednesday January 28, 2009
Status
Member
Last seen
February 1, 2009
- Jan 29, 2009 at 06:26 PM
paratrooper
Posts
2
Registration date
Wednesday January 28, 2009
Status
Member
Last seen
February 1, 2009
- Feb 1, 2009 at 04:24 PM
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

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

Jan 30, 2009 at 11:20 AM
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.
0
paratrooper
Posts
2
Registration date
Wednesday January 28, 2009
Status
Member
Last seen
February 1, 2009

Feb 1, 2009 at 04:24 PM
Hi,

Have you remembered the formula?

Thanks,

Paratrooper
0