I can't see the results (shading) when doing a "find" in Excel. V

H

hilreal

When doing a "find" the found cell is highlighted white and barely visible.
How can you change the highlighting for this operation?
 
G

Gord Dibben

No found cell is ever highlighted but It should have a black selection
border around it.

Do you mean multiple-return results?

After running the Find All command, hit CTRL + a in the "found" dialog box.

Then hit the "fill color" icon.


Gord Dibben MS Excel MVP
 
H

hilreal

After reading your response I went back and tried it and I guess I am NOT
getting the black border around the selection. It looks lighter than the
other cells but no distinquishing border. Any ideas how to turn it on?
 
G

Gord Dibben

I cannot replicate this on 2003 or 2007.

I get a black selection border around first found cell and as I move through
Find Next the selection changes to next instance and that cell gets the
border.

When you normally select a cell do you get the black border?


Gord
 
H

hilreal

Yes, when I manually select a cell I get a black border. When I do a "find"
the cell turns white but no border.
 
H

hilreal

Yes, when I manually select a cell I get a dark black border. When I do a
"find" opreation the selected cell turns white without a border.
 
G

Gord Dibben

Do you already have borders from Format>Cells>Border applied to the cells or
just the normal gridlines?

If you have borders applied, the selected cell will not have the heavy
outline.


Gord
 
G

Ginny90

I have the same issue. The color scheme of Excel 2007 is not good. The
found cell is practically invisible if your spreadhseet has gridlines. Is
there a way to change the background color of the 'found' cell temporararily
while its active (ie, the cursor is on it after a "Find")?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top