Conditional Formatting of text in another cell to match one cell

[rayted]

Hi guys

I have a large data set to filter through.

I have narrowed down my data set and require conditional formatting to save my time and ensure i detect any swear words left by customer reviews

Can anyone advise/help with a conditional formatting like so:

if a word in C2 is in I2, the specific text/character should be highlighted in red in I2? This would save me so much time and effort!

Sheet attachged.
Thanjk you!

[Bo_Ry]

Conditional Formatting can change color to all text, not by specific text.
VBA is need


Press Alt+F11
Insert Module and paste below code.
Press F5 to run

Please Login or Register  to view this content.

[rayted]

thank you bo_ry this is a good solution!