Hi,

Fir the 3 month (Yellow) fkag use this CF

=DATE(YEAR(A2),MONTH(A2)-3,DAY(A2))<=TODAY()

and for the red 1 change -3 to -1 and add a second cf

Mike

"Cinder the Dog" wrote:

I am trying to set up conditional formatting so that it flags me when it is
within 3 months & 1 month of a date. For example, I have a list of the dates
each of my staffs' CPR certifications are to expire. If it expires on
10/1/09, I would like the cell to turn yellow on 7/1/09, and red on 9/1/09.
The expiration date will be different for each staff member in each row.

Thanks