Thread: Making a date go red, if date passes todays date.
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
  
Posts: 2,420
Default 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?


Reply With QuoteReply With Quote