Forum Discussion
Solved
Highlight Future Expiration Dates
Hi there, I am surprised at how hard it is to find out how to highlight future expiration dates, as the dates are 30, 60, 90 days away. I find the "Format Cells that contain a date occurring" comp...
=AND(B2>=TODAY()+61,B2<=TODAY()+90)You can try this rule for conditional formatting (green).
=AND(B2>=TODAY()+31,B2<=TODAY()+60)You can try this rule for conditional formatting (yellow).
=B2<=TODAY()+30You can try this rule for conditional formatting (red).
=$B$2:$H$19This is the "applies to" range in the example.
For 3 different colors you have to enter 3 rules for conditional formatting. The screenshot shows the rules and the "applies to" ranges for conditional formatting.
JwalkerOCS You can use conditional formatting (highlight the range - in the example below it is B2:K11) and just tweak the formula for each format rule. It's important that the cell reference in the rule matches the upper left most cell in the "Applies to" box.
Formula in the "Rule" box
=AND(B2-TODAY()>60,B2-TODAY()<=90)
Hope this helps.
Dexter
- Thanks very much Dexter, I couldn't make this work for some reason, but it's definitely on this use not you! 🙂
