Time Sensitive Rule

Copper Contributor

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