conditional formatting

[Guest]

I want to create conditional formatting that will change the font color to
"red" and "bold" if the date is after the current date. The current date is
always contained in cell A1. How do I do this using the conditional
formatting option?

 

[Gord Dibben]

If the current date is in A1 where have you entered the date that will be after
the current date?

Assume =TODAY() in A1 and 11/23/2007 in B1

Select B1 and Format>CF>Cell Value is: greater than =$A$1


Gord Dibben MS Excel MVP