Previous Topic Next Topic

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
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
Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Keyboard troubles
jimbobjoe -
car -

38 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses