What is the formula to shade a cell when the date entered is less than todays
date?
--
Cheers,
Jodi

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


"Jodi" wrote:

What is the formula to shade a cell when the date entered is less than todays
date?
--
Cheers,
Jodi