View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Cheryl Cheryl is offline
external usenet poster
 
Posts: 144
Default conditional formating

The font color.


"T. Valko" wrote:

What are you formatting? The font color or the cell fill color?

--
Biff
Microsoft Excel MVP


"Cheryl" wrote in message
...
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.



.