Excel 2007 noncontiguous cell highlight color=light,light blue. How do I make it darker, or like Exc

[DCJM]

I have extreme shade blindness & need massive help. In Excel 2003, if I
select 5 noncontigious cells the last cell retains it's color while the 1st
4 become a darker color, like emerald green, charcoal or something, which I
can see and keep track of which cells I've selected. In Excel 2007 this
color is a blue so light that frankly I can't see it. How do I change this
color(& I guess in Excel 2010 also) back to the way it was in Excel 2003, or
something dark that I can see? Thanks, Dave

 

[Gord]

For 2007 and Windows XP.......have no idea about other versions of
Excel or Windows.

You can add or modify a key in the Registry if you are comforatble
hacking in the Regsitry.

Best to create a Restore Point before attempting any changes.

Start>Run regedit.exe

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

On right-side pane right-click on "Options6" and modify>decimal number
from 32 to 16.

If you don't have an Options6 you must create it by adding a new DWORD
value

Edit>New>DWORD

Rename to Options6 and set decimal value to 16

When selecting multiple cells, the color will be Black


Gord Dibben MS Excel MVP

 

[Rick Rothstein]

Start>Run regedit.exe

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

On right-side pane right-click on "Options6" and modify>decimal
number from 32 to 16.

If you don't have an Options6 you must create it by adding a new
DWORD value

Edit>New>DWORD

Rename to Options6 and set decimal value to 16

When selecting multiple cells, the color will be Black

Hey, that worked perfectly (Win7 64-Bit, Excel 32-Bit). Do you know if there
is a value that will make the selection a darker color other than black,
maybe a dark blue instead?

Rick Rothstein (MVP - Excel)

 

[Gord]

Rick

I am sure I tried a few different values and no luck.

Looks like black is all you get..........but feel free to
experiment<g>


Gord

 

[Rick Rothstein]

I am sure I tried a few different values and no luck.

Looks like black is all you get..........but feel free to
experiment<g>

I did try other numbers and kept getting black as well. I was hoping you
knew of another Options# to control the color in some way (I'm not willing
to experiment with those<g>). No matter... black is infinitely better than
that pale, pale, pale blue it used to be. Thanks.

Rick Rothstein (MVP - Excel)

 

[Jim Cone]

Gord/Rick,
My Windows XP system shows a value of 72 for xl 2003 and a value of 64 for xl2007 (both decimals
under option6).
I changed xl2007 to 72 and saw no immediate difference. I expect it may require a restart.
'---
Jim Cone



"Rick Rothstein" <[email protected]>
wrote in message

 

[Rick Rothstein]

My Windows XP system shows a value of 72 for xl 2003

and a value of 64 for xl2007 (both decimals under option6).
I changed xl2007 to 72 and saw no immediate difference.
I expect it may require a restart.

A restart of Excel, not Windows, right? Doing that shows that a value of 32
and above produces the same light, translucent shading whereas a value of 31
or less makes it solid black.

Rick Rothstein (MVP - Excel)

 

[Jim Cone]

Ok, thanks for the info.
'---
Jim cone




"Rick Rothstein" <[email protected]>
wrote in message

 

[DCJM]

To Gord, Rick & Jim. Thanks for your responses. It just shows there's mot a
solution for everything. Thanks again. Dave