Assume dates are in col A

Select col A (A1 active),
then apply CF using "Formula Is" for Conditions 1 to 3 as follows:

Condition 1:
=AND(A1<=TODAY(),A1<"")
Format Red fill/white font

Condition 2:
=AND(A1<=TODAY()+90,A1<"")
Format Yellow fill

Condition 3:
=AND(A1TODAY()+90,A1<"")
Format Green fill

Click to OK out
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Allan Skyner" wrote:
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.