Conditional Formatting in Excel 2007
 

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

Conditional Formatting in Excel 2007
 

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

Conditional Formatting in Excel 2007
 

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?
--
Glenda


"Gav123" wrote:

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

Conditional Formatting in Excel 2007
 

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" wrote:

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?
--
Glenda


"Gav123" wrote:

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

Conditional Formatting in Excel 2007
 

Thanks GAV,

--
Glenda


"Gav123" wrote:

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" wrote:

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?
--
Glenda


"Gav123" wrote:

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

Conditional Formatting in Excel 2007
 

thank you again, it works in 2007
--
Glenda


"Gav123" wrote:

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" wrote:

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?
--
Glenda


"Gav123" wrote:

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