Hi Glenda,

Not sure if this will work in XL2007 but...

Set your conditional format to Formula is and enter the formula


=OR(A1="word1",A1="word2",A1="word3")

Change cell reference and "word" for your own needs.

Selct your format.

Hope this helps,

Gav.

"Glenda" wrote:

I would like a cell to change color if the cell contains one of 2 specific
words (maybe 3 words?). The cell may contain that word alone or that word
and addtional words. I only need the formula, I know how to change the cell
format.

Thanks,
--
Glenda