Cond. Formating

C

Caroline

I would like to format dates prior to "today" in red. I have 2007.
My guess is I should use a formula when selecting a rule type, but <today()
doesn't seem to work.
Any ideas?
Thanks!
 
J

JW

Not sure how the dialog box looks in 2007, but in 2003, simply select
Cell Value Is, Less Than, and =Today() in the fields.
 
C

Caroline

Thanks, I tried that and it still didn't work. It formats everything (before,
after and even today's date). My cells are formated to "date" so that's not
the problem.
Scratching my head...
 
D

David Biddulph

Are you sure that as well as being formatted to date the cells actually
contain dates, not text?
If you've got today's date in a cell, change the format temporarily to
number and see whether it shows 39345.
Also, go back into the CF dialog box and make sure that it is really showing
what you think you've put in there, and (for example) that it hasn't thrown
spurious quote marks around anything (which it tends to do if (for example)
you didn't type in the = before today().
 
C

Caroline

That was it: the = sign. I thought since it added it anyways I didn't have to
put it in, but it turned out I did.
Thanks much!
 
Top