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

Copper Contributor

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?

1 Reply

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