Making a date go red, if date passes todays date.
I want to be able to enter a future date that would be black when entered,
and then go red when that date passes. (to show urgent/out of date work). Is this possible? |
Making a date go red, if date passes todays date.
Yes. Look up "conditional formatting" in Excel help.
-- David Biddulph "Jamie" wrote in message ... I want to be able to enter a future date that would be black when entered, and then go red when that date passes. (to show urgent/out of date work). Is this possible? |
Making a date go red, if date passes todays date.
Use conditional formatting with a formula of =A1<TODAY()
-- __________________________________ HTH Bob "Jamie" wrote in message ... I want to be able to enter a future date that would be black when entered, and then go red when that date passes. (to show urgent/out of date work). Is this possible? |
All times are GMT +1. The time now is 02:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com