A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Setting up and Configuration
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old March 23rd, 2009, 06:52 PM posted to microsoft.public.excel.setup
hilreal
external usenet poster
 
Posts: 4
Default I can't see the results (shading) when doing a "find" in Excel. V

When doing a "find" the found cell is highlighted white and barely visible.
How can you change the highlighting for this operation?
  #2  
Old March 23rd, 2009, 11:23 PM posted to microsoft.public.excel.setup
Gord Dibben
external usenet poster
 
Posts: 20,252
Default I can't see the results (shading) when doing a "find" in Excel. V

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


On Mon, 23 Mar 2009 11:52:03 -0700, hilreal
wrote:

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


  #3  
Old March 24th, 2009, 03:18 PM posted to microsoft.public.excel.setup
hilreal
external usenet poster
 
Posts: 4
Default I can't see the results (shading) when doing a "find" in Excel

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?

"Gord Dibben" wrote:

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


On Mon, 23 Mar 2009 11:52:03 -0700, hilreal
wrote:

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



  #4  
Old March 24th, 2009, 04:02 PM posted to microsoft.public.excel.setup
Gord Dibben
external usenet poster
 
Posts: 20,252
Default I can't see the results (shading) when doing a "find" in Excel

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


On Tue, 24 Mar 2009 08:18:01 -0700, hilreal
wrote:

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?

"Gord Dibben" wrote:

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


On Mon, 23 Mar 2009 11:52:03 -0700, hilreal
wrote:

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




  #5  
Old March 24th, 2009, 04:50 PM posted to microsoft.public.excel.setup
hilreal
external usenet poster
 
Posts: 4
Default No Border

Yes, when I manually select a cell I get a black border. When I do a "find"
the cell turns white but no border.
  #6  
Old March 24th, 2009, 04:51 PM posted to microsoft.public.excel.setup
hilreal
external usenet poster
 
Posts: 4
Default No border

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.
  #7  
Old March 24th, 2009, 09:33 PM posted to microsoft.public.excel.setup
Gord Dibben
external usenet poster
 
Posts: 20,252
Default No Border

Do you already have borders from FormatCellsBorder applied to the cells or
just the normal gridlines?

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


Gord

On Tue, 24 Mar 2009 09:50:03 -0700, hilreal
wrote:

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


  #8  
Old October 22nd, 2009, 02:24 PM posted to microsoft.public.excel.setup
Ginny90
external usenet poster
 
Posts: 1
Default I can't see the results (shading) when doing a "find" in Excel

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")?


"Gord Dibben" wrote:

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


On Tue, 24 Mar 2009 08:18:01 -0700, hilreal
wrote:

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?

"Gord Dibben" wrote:

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


On Mon, 23 Mar 2009 11:52:03 -0700, hilreal
wrote:

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




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:51 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.