Conditional formatting referencing date of expiration

  • Thread starter Thread starter FIRE GIRL
  • Start date Start date
F

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.
 
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
 
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??
 
THAT WORKED!!!
THANK YOU!


Any chance you have a 'cheat sheet' for formulas handy or know where i can
find one? :-)
 
You're welcome!
Any chance you have a 'cheat sheet' for formulas handy or know where i can
find one?
Click to expand...

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.
 
Back
Top