Excel Conditional formatting looking for date - 30 days change cell color
Posted on 2016-09-16
I need a conditional format that will change a cell to yellow if the date is 30 or 60 or 90 days before today's date.,
Example, I have a column of expiry dates, (actually multiple columns but I will just copy to others later), I need to change cell color to when date is about to expire.
If cell's date is expiring 30 days from today or already expired then turn cell yellow.
If I could use a cell to dictate the 30 - 60 - 90 in the formula that would be awesome.