Forum Discussion
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 ...
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.
Hello Sergei
This worked a treat. Thanks for taking the time to help a novice out.
Cheers
Nick