The easiest approach would be to put a filter on the column where you have
the word"NEW"using data--Filter-- Autofilter command.
Then select the word "new" from the drop down
Now select the range which has the word new and simply change the color of
the selected range.

You may now remove the Autofilter

"cutilee" wrote:

cHi,
I am trying to change the colour of a reocuring word in my workbook. How do
I do that? I tried find and replace but that changes all the text in each
row. I just want a particular word to be highlighted.

For example, the word is New!
It appears quiet a few tme in some columns and I want to change the colour
to red so it stands out.

Can someone help me, I would really appreciate it.
Thanks
Kareem.