It's called conditional formatting.

Depending on what version of Excel you're using you may be limited to 3
conditions. (Excel 2007 unlimited*) You have 4 conditions. To get around
that you can use 1 condition as the default condition. Looking at what you
want the default color should be BLACK. So, set the fill color of the cell
in question to BLACK.

Now, set the conditional formatting
Select the cell you want to color
Goto the menu FormatConditional Formatting

Condition 1
Formula Is: =G62="Go"
Clcik the format button
Select the Patterns tab
Select GREEN
OK

Click the Add button and repeat the above process for the other conditions.

* limited only by available memory

Biff

"hopebear" wrote in message
...
I am not sure what this function is called. The cell can be programmed
that
if the result is 0 or 1 or 2 or 3 - color will display instead of the
number.
So 0 is black, red, green, yellow. sample formula is IF(G62="GO", 1,
IF(G62="BUY", 2, IF(G62="SELL", 3,0))) then the cell will show the
corresponding color (0,1,2,3 - black, green, yellow, red).

My questions a
1. what is this called? so I can search in 'HELP'.

2. are there more than 4 colors (B,G,R,Y)? I like few more and their
corresponding value. How do I go about finding this out? I am looking
for
navy blue (and maybe more later).

Thank you so very much.