Conditional formatting dates due to expire
I have a column in a spreadsheet which lists the various dates a lease will
expire. What I would like to do is to change the format to yellow when the
date is due in 90 days, (in other words give me a 3 month warning), and
change to red when the date is reached and past. All the other dates will be
green to signify lease is still current. Thanking anyone in advance.
|