Column Possible

[Tango]

Is it possable to have a cell compare the cell date to "Today" and if
"Today" is older then the cell then turn the cell red with white
letters.

TIA
Tango

 

[Bob Phillips]

Yes, use conditional formatting with a formula of

=C1>TODAY()

See http://www.contextures.com/xlCondFormat01.html

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)