Highlight row if a word is found anywhere in another column

Hi all...

I'm not sure if my brain is still on Holiday or what, but I can't seem to figure out how to get this to work.

All I want to do is have excel look down column B, and if it sees the word "graphic", it would highlight the corresponding cell in column J.

The word graphic can be any anywhere amongst other words in column B ... so it could be "Corner Graphic" or "Corner Graphic - Front" ... so it would have to look for the word, but it will never be an exact match.

Conditional formatting is fine, and I've tried

=SEARCH(“graphic”,B:B)

and I've tried

=B:B="*Graphic*"

, but neither worked.

This seems like it should be easy, but my brain must still be on vacation.

Thanks for any help in advance!

How about

Formula:

=SEARCH("graphic",B2)

change the 2 to match the 1st row in the applies to range

Yes!!! That did it... I was so close! haha... thank you!

You're welcome & thanks for the feedback.