Forum Discussion
Nickcliviascomau
Feb 10, 2019Copper Contributor
Excel formula help
I would like to search to find values in quite a few excel sheets and have the search result cells highlighted in a colour for visual recognition. Is this possible? My situation is that I have a ...
SergeiBaklan
Feb 11, 2019Diamond Contributor
Hi Nick,
You may use Find & Replace, in "Replace with" is the same string as in Find, in "Format" for the "Replace with" change format as you'd like to highlight. In options "Within" choose workbook and Replace All after that.
Nickcliviascomau
Feb 13, 2019Copper Contributor
Hello Sergei
This worked a treat. Thanks for taking the time to help a novice out.
Cheers
Nick