Conditional formatting

[David]

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

 

[Guest]

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]

Thanks - that works but for future reference I would
still like to know how to code colors in formula

David