Thread: conditional formating
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cheryl Cheryl is offline
external usenet poster
  
Posts: 144
Default conditional formating
I have the following formula for column D and E
=D2<Today() red
=(D2-Today())<30 green
I need to add a formula that if a date is in column c then column D and E
are black.

Reply With QuoteReply With Quote