View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Find utility, highlighting answer

After running the "Find All", hit CTRL + a to select all cells in the
"Found" dialog box.

Then hit your colorpicker to color the cells darker.

If you want a permanent fix for the selected cells coloring in Excel 2007
here is a Registry hack.

StartRun regededit.exe

Drill down to

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\E xcel\Options

Right-click on Options6 and ModifyDecimal........change the 32 to 16

When you select multiple cells all but the active cell will be black.


Gord Dibben MS Excel MVP

On Fri, 26 Feb 2010 06:26:01 -0800, Phil C
wrote:

In the older version of Excel when I used the find utility it would highlight
the cells found in a different shade.

When I use the same utility in Excel 2007 the highlighting is bearly
visable, so I cannot see what I searched for.

Is there a way I can change this so the highlighted result is more visable ?.