Forum Discussion
How to identify "found" excel cells
After searching for excel cells using Find, I have trouble locating the cells that have been found. Is there a way to "tell" Find that I want the "found" cells highlighted by border or color so they are easier to locate after the search?
1 Reply
I believe you could use replace. Replace it with the same text, but with a different format.
Say I wanted to search for cells containing "a". So, I replace it with "a" and a yellow fill color.
