Conditional format portion of text within a cell

Hello,

I have a big worksheet with lots of text.

I'm particularly interested in one keyword "cropspray" which appears in most cells. I want to identify whenever it occurs. However, because it is so frequent, I only want to identify the word itself, and not the whole cell.

In the attached example I've colored it red manually. I'd like instead to run some code and highlight those words in yellow automatically.

Grateful for any help.

Thanks,

HE

Try this ...

Please Login or Register  to view this content.

Call with this ...

Please Login or Register  to view this content.

Similliar but with Input box:

Please Login or Register  to view this content.

However, it works for single cell and still can't figure out why don't work for a range...
Marcol, maybe you see it...

Change this line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

You'll also have to consider the text formatting i.e. "cropspray" and "Cropspray"

Thanks...

Of course, upper/lower case can be applied if needed.
I've edited my post.

@ zbor
I might have missed what you are trying to do

Try this line instead

Please Login or Register  to view this content.

You would need to adopt Lcase function in case you wand to highlight all cases (ab, Ab, aB, AB)...

Please Login or Register  to view this content.