Excel 2007 : How can i highlight the exact matching word when sorting text?

For example, i want to highlight all cells in a column that contain the word "run" and i don't want to highlight the cells that contain the word "running". I want to highlight only the exact word and the words that contain part of this word.


How can i do this?


Thanks!

Did you try the built in Find and Replace?

Ctrl+ H
Find what: run
Replace with: run

Expand Options
For Replace with: run >> Format: Pick what you desire

Check Match entire cell contents
Replace All

In my test with run and running only run was highlighted.

@Jeff: it sounds as though there might be other words in the cell. For example:

I can run
running man
run to me
fastest runner
I run too

And, if I'm correct, the OP only wants the cells with "run" but not "runner" or "running".

Regards

Originally Posted by emil9216

For example, i want to highlight all cells in a column that contain the word "run" and i don't want to highlight the cells that contain the word "running". I want to highlight only the exact word and the words that contain part of this word.

Maybe I misread your request the first time as I often do.

Are you saying "ONLY" the word running should be excluded, but if the word contains run then it should be hightlighted?

run >> Highlight
running >> No Highlight
Runner >> Highlight
Runt >> Highlight
Crunchiness >> Highlight
Runoff>> Highlight

Please Login or Register  to view this content.

Here you go.

This will highlight all occurences of the word run in column A.

The only thing which was tripping me up was the prevention of highlighting Running, I put it into an If statement to exclude Running, but then running would get highlighted so had to add another If statement. I know there must be a way to ignore the case, but just not sure. Give this a try and maybe somebody else can offer some suggestions.

Please Login or Register  to view this content.

Use:

Please Login or Register  to view this content.

Regards

That works great, thanks. I had tried UCase and it didn't work, but for whatever reason I did not try the LCase...go figure