Highlight row if a word is found anywhere in another column

[WaveWalker116]

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

Please Login or Register  to view this content.

and I've tried

Please Login or Register  to view this content.

, but neither worked.

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

Thanks for any help in advance!

[Fluff13]

How about

Please Login or Register  to view this content.

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

[WaveWalker116]

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

[Fluff13]

You're welcome & thanks for the feedback.