Oops, thanks for the catch!

"Alan Cannon" wrote in message
...
Actually, it should be Cell Value is less than today().

"Barb Reinhardt" wrote in message
...
I've used conditional formatting to do this. Format - Conditional
Formatting

Cell Value is greater than today(). Format that in red.

"Jimbob" wrote in message
...
I want to show passed dates in red auttomatically anyone know hoew to
do
it?