View Single Post
  #5   Report Post  
Jimbob
 
Posts: n/a
Default



"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