G
Guest
I want to show passed dates in red auttomatically anyone know hoew to do it?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Barb Reinhardt
I've used conditional formatting to do this. Format -> Conditional
Formatting
Cell Value is greater than today(). Format that in red.
Formatting
Cell Value is greater than today(). Format that in red.
it?Jimbob said:I want to show passed dates in red auttomatically anyone know hoew to do
A
Alan Cannon
Actually, it should be Cell Value is less than today().
B
Barb Reinhardt
Oops, thanks for the catch!
Alan Cannon said:Actually, it should be Cell Value is less than today().
G
Guest
Barb Reinhardt said:I've used conditional formatting to do this. Format -> Conditional
Formatting
Cell Value is greater than today(). Format that in red.
it?
Thanks thats great I used 'less than' and it works well. Thanks very much