Conditional formatting referencing date of expiration

[FIRE GIRL]

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.

 

[T. Valko]

Try this:

Select cell A2
Goto the menu Format>Conditional 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

 

[FIRE GIRL]

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]

If I understand, change the formula to:

=A2<=$G$5

 

[FIRE GIRL]

THAT WORKED!!!
THANK YOU!


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

 

[T. Valko]

You're welcome!

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

Maybe this:

http://homepage.ntlworld.com/noneley/

I do something similar except I keep a library of formulas in separate files
and I tend to only "catalogue" the really complex formulas. Right now I have
349 sample files and each file contains dozens of formula variations.

One of these days I'd like to compile all these formulas into a book or do
something similar to what Peter did.