Ask a question Report

Excel 2010 date formula conditional question

Andy - Latest answer on May 10, 2012 09:07AM

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

Excel 2010 date formula conditional question
Format based on another cell? (Solved) » Forum - Office software
Excel - A formula to add a specific number of days » How-To - Excel
Unable to change date format in Excel (Solved) » Forum - Excel
Excel date format won't change (Solved) » Forum - Excel
Excel - Hide/Unhide the Formula bar » How-To - Excel

Answer

TrowaD 741Posts Sunday September 12, 2010Registration date ContributorStatus May 16, 2013Last seen May 10, 2012 09:07AM

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

Add comment

Reply to this topic

Ask a question

Not a member yet?

sign-up, it takes less than a minute and it's free!

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.

Excel 2010 date formula conditional question

Not a member yet? sign-up, it takes less than a minute and it's free!

Not a member yet?

sign-up, it takes less than a minute and it's free!