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 ?.
|