Hello!
I am using the forum some time now but just registered because I tried some suggestions already posted but no luck
I have a column in Excel 2013 with certificate Due Dates:
If the certificate overdue: Red
If the certificate expires in 90 days/ 3 months form today: Yellow (for those 3 months until expiry)
If the certificate expires in more than 90 days: Green (for those 9 months until expiry)
(I don't mind about the "=" in the dates can be in any of the above stages)
Maybe the issue is the order that I have place in Conditional Formatting although or the "Stop if true" I have tried several.
Thank you so much for your kind assistance.
Natalia
I am using the forum some time now but just registered because I tried some suggestions already posted but no luck
I have a column in Excel 2013 with certificate Due Dates:
If the certificate overdue: Red
If the certificate expires in 90 days/ 3 months form today: Yellow (for those 3 months until expiry)
If the certificate expires in more than 90 days: Green (for those 9 months until expiry)
(I don't mind about the "=" in the dates can be in any of the above stages)
Maybe the issue is the order that I have place in Conditional Formatting although or the "Stop if true" I have tried several.
Thank you so much for your kind assistance.
Natalia