Sagan:

Try this in your CF:

In cell A1, click FormatConditional Formatting...

Condition 1:

Formula Is: "<Today()" (no quotes).

Set desired formatting.

You don't need to reference the cell you are in if the value of that
cell is what you are basing your condition on.

Also works:

Cell value Is: Less Than: ="today()" (entered exactly as shown)

HTH

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=469507