Changing the default highllight for selected cells?

[MJK4158]

I am new to 2007 XL and the highlighting for selected cells shows such a
minimal difference to the original cell highlight (color) that it is very
hard to distinguish between what is and is not selected... Any way to change
or update the default highlight change for selected cells?

 

[Mike H]

Hi,

No you can't change the default but Chip Pearson has this rowliner addin

http://www.cpearson.com/Excel/RowLiner.htm
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

 

[MJK4158]

NUTS! I was afraid of that...

Is there any other way (other than the rowliner add-in) to make the
selections (particulary when selecting disconnected cells via the crtl key)
more noticeable - ie a general format change?

Thanks Mike...

 

[Gord Dibben]

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

Start>Run regededit.exe

Drill down to

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Options

Right-click on Options6 and Modify>Decimal........change the 32 to 16

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


Gord Dibben MS Excel MVP