Highlight Search Results

E

edo

Using Excel, how does one chage the settings to all the search results to be
more evident...possibly highlighted?
 
G

Gord Dibben

Once the cells are found under "Find all" you can SHIFT + down arrow in the
"found" dialog box which selects all the found cells on the sheet.

Format>Cell>Patterns. Pick a color.


Gord Dibben MS Excel MVP
 
Top