limit is 3. You can, however, check for the appearance of the word by some
formula like
=NOT(ISNA(MATCH(A1,F1:F8,0)))
where F1:F8 contains the list of 8 words and A1 is the active cell. If it's
not an error, the word exists, and you can make the cell be whatever color
you want. You just can't have 8 different colors.
Bob Umlas
Excel MVP

"Jerry Kinder" wrote in message
...
How do I set more that 3. I need 6 or 8.

I want to have color of cell change if one of the 6 or 8 words appears in
the cell.

Thanks,
Jerry