If you have Excel 2007, yes. If not your would need VBA


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


unless it would fit these requirements

http://www.mcgimpsey.com/excel/conditional6.html


--


Regards,


Peo Sjoblom


"steve-o" wrote in message
...
Hi All:

I would like to use conditional formatting on a spreadsheet where a row in
a
spread sheet's color depends on the value of one of the cells on a row,
called the status cell. However, I would like to have six colors
representing six different values in the status cell. Is there a way to
implement this conditional formatting?

Thanks in advance,

steve-o