Excel 2010 date formula conditional question

[Closed]
Report
-
Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
-
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

Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
486
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