How to identify "found" excel cells

Copper Contributor

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

@mitsu0F4U109 

 

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.