This does not work. Nothing has changed is there another formula I can use?

"akphidelt" wrote:

Press CTRL-A to highlight the entire page. Then go to Format-Conditional
Formatting and put

Cell Value is equal to New

And change the format

"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.