Hi
if you don't mind using a beta release addin try:
http://www.xldynamic.com/source/xld.....Download.html

It will just do this

--
Regards
Frank Kabel
Frankfurt, Germany

"terrapinie" schrieb im Newsbeitrag
om...
I've seen some of the other solutions for conditional formatting with
more than 3 conditions - and I just cannot seem to get them to work
for me.

I have a spreadsheet that is created by exporting information from an
online database. I want some of the cells to be automatically
colored
depending on what is inside them.

For example, in column C is the Status. For cells with the word
'LOST', I want them filled black with white text. For cells with the
word 'CONTRACT', I want them filled blue with white text. Cells that
say 'PROPOSAL', I want them green with white text. And those with
the
word 'INACTIVE' or 'ABANDONED', I want them brown with white text.
And these colors only need to be in this column of cells (not spread
across the row).

In column B is the Type. For cells with the word 'RECOMPETE', I want
the text to be blue. This needs to be for that particular cell in
column B and it's preceding cell in column A.

In column L, the rows are assigned with a numerical value, 0 through
4. I want the cell to be filled with a different color depending on
which number is assigned.

There has to be a method to do this (I hope). Can anyone shed some
light??

Thanks so much,
Laurie