Forum Discussion
tzeleong
Nov 01, 2023Copper Contributor
Search text in cell and if match, mark text with colour (Automatically)
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?
SanthoshKunder
Nov 01, 2023Iron Contributor
tzeleong -Not sure if this what you are looking for . Select the entire sheet and apply this conditional formatting.