![]() |
Column Possible
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 |
Column Possible
Yes, use conditional formatting with a formula of
=C1TODAY() See http://www.contextures.com/xlCondFormat01.html -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Tango" wrote in message ... 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 |
All times are GMT +1. The time now is 06:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com