First question: are you sure that you've got real dates, rather than text?
What do =ISTEXT(A2) and =ISNUMBER(A2) return? What does your 8/3/2009 show
if you temporarily format the cell as General instead of date?
Secondly, exactly what do you have in the "Formula Is" field in Conditional
Formatting? Copy your formula from that field and paste it here. Stefi
forgot the = signa at the start of the formula, so there is a danger than
Excel will have thought you were defining a text string and put quote marks
around your formula.
--
David Biddulph

"Inward-Smile(Meka)" wrote in
message ...
Hi Stefi,
Thanks for responding to my post. I input the above information but
nothing
happened. For example, a one cell contained "8/3/2009", yet it did not
have
the "Red" color highlight or any color within the cell. Is there
something
else I'm missing



"Stefi" wrote:

Sorry, for green of course A2<Today()+60
Stefi


"Stefi" ezt írta:

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 :)