Format "find results" so that they are hi-lighted?

[Shelly]

I use the "find" function to search for words in an excel spreadsheet and
when the results are shown, the cell on the spreadsheet is not highlighted
and it is hard to see. Any way to change the formatting so that the cells
that match the find results are hi-lighted?

Thanks.

 

[Rick Rothstein \(MVP - VB\)]

Yep, if they are not highlighted, I guess they would be hard to see.<g>

Seriously, though, I presume you are clicking the Find All button to find
all of the cells matching your search condition. After you have done that,
press Ctrl+A to select all of the cells. You can now Close the dialog box
and the cells will remain selected.

Rick

 

[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