RE: Conditional formatting

From: Remus (Remus_at_discussions.microsoft.com)
Date: 08/13/04 

Date: Fri, 13 Aug 2004 04:13:01 -0700

Try changing the condintional formatting so that the text colour is the same
as the background colour. Then you shouldn't be able to see it.

"David" wrote:

> I have three columns E for a Target Date, F for a closed
> Date and H for Today's date with the following statement
> in column G which is for Status
> =IF(F2=0,IF(E2>$H$2,"In Progress","Late"),"Completed")
> This works but I want to return colors instead of text in
> column G. I set up conditional formatting using three
> cell colors RED for Late, YELLOW for In Progress and
> GREEN for Completed and this returns colors and text. All
> I can do is reduce the font size to 1 but I can't make it
> transparent. Ideally what I want is to replace the words
> with colors in the formula but I can't find the code -
> can you help?
>
> David
>
>

Loading