If your exp. dates are in column A, then
formula for red: A2<Today()
for yellow: A2<Today()+30
for green: A2<Today()+30

Regards,
Stefi

€žInward-Smile(Meka)€� ezt Ã*rta:

Hey,
Need help with the following problem, hope someone can help. see below:
I'm created a spreadsheet with a column for "Employee Driver's License Exp.
Dates". I want to setup a rules that format certain cells to be highlighted
in red, when they expire anytime before today's date.
Second, I want to highlight cells "Yellow", if the date within a cell is
within 30 days of the expiration date.
Lastly, and third, I would like to highlight cells "Green", if the cell's
date is within 60 days of expiration.
Any suggestions or explicit, detailed instructions would be greatly
appreciated. I tried the Demo in Microsoft Excell 2003, but I ended up
making all my cells "Red"! Yeesh
Please help :)