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 ...
The following formula should work in Conditional Formatting for you. Change A1 to the cell where your date is located =A1-TODAY()<90