Previous Topic Next Topic

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
Related:

2 responses

Answer 1 / 2
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
Answer 2 / 2
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

Similar discussions

encryption message several time in chat
measking -
HelpiOS -

1 response
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses