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

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.

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

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


"Shelly" wrote in message
...
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.

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

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.

FormatCellPatterns. Pick a color.


Gord Dibben MS Excel MVP


On Thu, 10 Jul 2008 10:40:01 -0700, Shelly
wrote:

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.