THAT WORKED!!!
THANK YOU!


Any chance you have a 'cheat sheet' for formulas handy or know where i can
find one? :-)

"T. Valko" wrote:

If I understand, change the formula to:

=A2<=$G$5

--
Biff
Microsoft Excel MVP


"FIRE GIRL" wrote in message
...
Okay, that worked! but my next problem... it is only applying the formula
if
the dates are EXACTLY the same... can i make it so if it is today or any
day
AFTER today it will continue the formatting??

"T. Valko" wrote:

Try this:

Select cell A2
Goto the menu FormatConditional Formatting
Select the Formula Is option
Enter this formula in the little box on the right:

=A2=$G$5

Click the Format button
Select the desired style(s)
OK out

--
Biff
Microsoft Excel MVP


"FIRE GIRL" wrote in message
...
I'm trying to apply conditional formatting to a cell, to show it has
expired
when today's date equals the date of expiration.

I have the =today() formula in a cell for reference, however the
conditional formatting changes immediately even though the two cells
are
not
equal..

What am i doing wrong??
example:

cell A2 is the date of expiration- 7-1-2012
cell G5 is today's date- 8-15-2008

when they are equal to each other, the conditional formatting should
apply.