You can use the CHOOSE() function. See Excel Help. CHOOSE can handle up to
29 different picks.
--
Gary's Student


"tjack13" wrote:

Thanks, that did it. Since there were 8 colors, I was able to get by
with the seven levels of IF nesting. Do you know of a way to deal with
more color options?

Todd

Gary''s Student wrote:
First enter a little function to return the color of a cell:

Function colorcode(cell As Range) As Integer
colorcode = cell.Interior.ColorIndex
End Function

Then if you want to set the value of A1 based upon its color, enter the
formula:

=if(colorcode(A1)=15,"CANCELLED","")

You will probably need to re-calculate the worksheet if you change cell
colors because Excel may not realize the function colorcode will have to be
re-executed.