Conditional Formatting in Excel 2007

[Glenda]

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,

 

[Gav123]

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]

The original question should have included that the word might be one in a
string of words (this is a 'comments' column).

Building on your response, I thought
=OR(A1="*word1*",A1="*word2*")
would work, but obviously I'm putting the wildcard at the wrong place?

 

[Gav123]

Ok you could try setting up 2 conditions for the words you want and try this
in your conditional formatting...

CF1
Formula Is ..

=SEARCH("*word1*",A1)

CF2

Formula Is....

=SEARCH("*word2*",A1)

Hope this helps

Gav

 

[Glenda]

Thanks GAV,

--
Glenda

Ok you could try setting up 2 conditions for the words you want and try this
in your conditional formatting...

CF1
Formula Is ..

=SEARCH("*word1*",A1)

CF2

Formula Is....

=SEARCH("*word2*",A1)

Hope this helps

Gav

 

[Glenda]

thank you again, it works in 2007
--
Glenda

Ok you could try setting up 2 conditions for the words you want and try this
in your conditional formatting...

CF1
Formula Is ..

=SEARCH("*word1*",A1)

CF2

Formula Is....

=SEARCH("*word2*",A1)

Hope this helps

Gav