Not sure how the dialog box looks in 2007, but in 2003, simply select
Cell Value Is, Less Than, and =Today() in the fields.
Caroline wrote:
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!