I want to show passed dates in red auttomatically anyone know hoew to do it?
B Barb Reinhardt Jul 1, 2005 #2 I've used conditional formatting to do this. Format -> Conditional Formatting Cell Value is greater than today(). Format that in red. Jimbob said: I want to show passed dates in red auttomatically anyone know hoew to do Click to expand... it?
I've used conditional formatting to do this. Format -> Conditional Formatting Cell Value is greater than today(). Format that in red. Jimbob said: I want to show passed dates in red auttomatically anyone know hoew to do Click to expand... it?
B Barb Reinhardt Jul 1, 2005 #4 Oops, thanks for the catch! Alan Cannon said: Actually, it should be Cell Value is less than today(). Click to expand...
Oops, thanks for the catch! Alan Cannon said: Actually, it should be Cell Value is less than today(). Click to expand...
G Guest Jul 1, 2005 #5 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 Click to expand...
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 Click to expand...