Search text in cell and if match, mark text with colour (Automatically)

[tzeleong]

I wish to search text within an Excel file and if it matches, I wish to change the colour of the matched text. How do I run this automatically via a script or macro?

[#2]

@tzeleong -Not sure if this what you are looking for . Select the entire sheet and apply this conditional formatting.