Forum Discussion
Hannah-Joy Waechter
Sep 27, 2018Copper Contributor
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 ...
BobOrrell
Sep 27, 2018Iron Contributor
The following formula should work in Conditional Formatting for you. Change A1 to the cell where your date is located =A1-TODAY()<90