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
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
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:
- Dates in Excel
- Gif in excel - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Number to words in excel - Guide
- Marksheet in excel - Guide
- Kernel for excel - Download - Backup and recovery
2 responses
CLFmagic
Posts
1
Registration date
Thursday January 29, 2009
Status
Member
Last seen
January 30, 2009
Jan 30, 2009 at 11:20 AM
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.
Using conditional formatting and a formla which becomes true when the current date + 30 becomes larger
than the date you have set.
paratrooper
Posts
2
Registration date
Wednesday January 28, 2009
Status
Member
Last seen
February 1, 2009
Feb 1, 2009 at 04:24 PM
Feb 1, 2009 at 04:24 PM
Hi,
Have you remembered the formula?
Thanks,
Paratrooper
Have you remembered the formula?
Thanks,
Paratrooper
