Excel 2010 date formula conditional question
Closed
Andy
-
May 9, 2012 at 08:55 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 10, 2012 at 09:07 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 10, 2012 at 09:07 AM
Hello,
I have a date a visa was issued. The visa expires 1 year from that date. I wish to highlight the relevant column in Red to mark that is due to expire in 30 days, or green if its older than 30 days remaining. How do I use conditional formatting to complete this task.
Thanks
I have a date a visa was issued. The visa expires 1 year from that date. I wish to highlight the relevant column in Red to mark that is due to expire in 30 days, or green if its older than 30 days remaining. How do I use conditional formatting to complete this task.
Thanks
Related:
- Excel 2010 date formula conditional question
- Microsoft office 2010 free download - Download - Office suites
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Pdf and xps add in 2010 - Download - Other
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
May 10, 2012 at 09:07 AM
May 10, 2012 at 09:07 AM
Hi Andy,
If A2 contains the date the visa was issued and B2 contains the current date [=TODAY()], then try these two formula's within conditional format:
=B2-A2>=335 ... RED
=B2-A2<335 ... GREEN
Best regards,
Trowa
If A2 contains the date the visa was issued and B2 contains the current date [=TODAY()], then try these two formula's within conditional format:
=B2-A2>=335 ... RED
=B2-A2<335 ... GREEN
Best regards,
Trowa