I want to show passed dates in red auttomatically anyone know hoew to do it?

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?

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?

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?

"Barb Reinhardt" wrote:

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?


Thanks thats great I used 'less than' and it works well. Thanks very much