I am looking for a way to use conditional formatting for a column to identify
if a particular word is entered into the cells.

is there only one word per cell that you are looking for or are you looking
at cells with a number of words of which you want to find one?

If there is one word per cell then it should be relativley easy to use
conditional formating to check if the cell contents 'is equal to' to the word
you are looking for and then fill the cell with a color of your choice.

"MW" wrote:

I am looking for a way to use conditional formatting for a column to identify
if a particular word is entered into the cells.

In your conditional formatting formula put:

=NOT(ISERROR(SEARCH("search string",E7)))

You can replace "search string" with a cell reference for flexibility. In
the above formula, E7 would be your own location in your sheet which
contains the text you are searching.



"MW" wrote in message
...
I am looking for a way to use conditional formatting for a column to
identify
if a particular word is entered into the cells.

the cells would contain a description of the item such as "999-1B-drying
oven" or "stopper process depyro oven"
I have a list of key words I am searching for within these descriptions such
as
"oven" "incubator" "autoclave"

I'd like to be able to reference the list and use conditional formatting to
change the cell color if one of the words from the list is in a cell within
the column.


"tim m" wrote:

is there only one word per cell that you are looking for or are you looking
at cells with a number of words of which you want to find one?

If there is one word per cell then it should be relativley easy to use
conditional formating to check if the cell contents 'is equal to' to the word
you are looking for and then fill the cell with a color of your choice.

"MW" wrote:

I am looking for a way to use conditional formatting for a column to identify
if a particular word is entered into the cells.