Forum Discussion
Time Sensitive Rule
Hello Team!
I'm trying to create a spreadsheet with a column for dates that will turn red when they are within 3 months of expiring on today's date. How would this rule be formatted? Thank you for your help!
1 Reply
- The following formula should work in Conditional Formatting for you. Change A1 to the cell where your date is located =A1-TODAY()<90
