ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Changing the default highllight for selected cells? (https://www.excelbanter.com/excel-discussion-misc-queries/259553-changing-default-highllight-selected-cells.html)

MJK4158

Changing the default highllight for selected cells?
 
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

Changing the default highllight for selected cells?
 
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" wrote:

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?


MJK4158

Changing the default highllight for selected cells?
 
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...

"Mike H" wrote:

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" wrote:

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?


Gord Dibben

Changing the default highllight for selected cells?
 
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 Mon, 22 Mar 2010 13:32:01 -0700, MJK4158
wrote:

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

"Mike H" wrote:

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" wrote:

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?




All times are GMT +1. The time now is 02:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com