Conditional formatting

From: David (anonymous_at_discussions.microsoft.com)
Date: 08/13/04


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

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