It is called FormatConditional Formatting.

In Excel versions 97 through 2003 you can have have 3 conditions......4 if you
count the default. 2007 has many more.

For a list of the colors in the 56 color palette see David McRitchie's site.

http://www.mvps.org/dmcritchie/excel/colors.htm

Bob Phillips has an add-in that allows up to 30 condtions.

http://www.xldynamic.com/source/xld.....Download.html


Gord Dibben MS Excel MVP

On Wed, 2 May 2007 13:39:02 -0700, hopebear
wrote:

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.