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 FormatCFCell Value is: greater than =$A$1


Gord Dibben MS Excel MVP

On Wed, 10 Oct 2007 21:24:00 -0700, MelB wrote:

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?