Try Conditional Formatting:
Select the cells to be imacted
(I'll assume A2:A10, with cell A2 as the active cell
From the Excel main menu:
<format><conditional formatting>
Formula is: =AND(A2<>"",A2<TODAY())
Click the [Format] button and select the pattern for the cells less than today
Click the [OK] buttons...and you're done.
Does that help?
***********
Regards,
Ron
XL2002, WinXP
