Excel 2010 date formula conditional question

Closed
Andy - May 9, 2012 at 08:55 AM
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 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

1 reply

TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
509
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
0