Excel 2007 noncontiguous cell highlight color=light,light blue. How do I make it darker, or like Excel 2003 ( I'm extremely shade blind-PLZ HELP !! )

DCJM

unread,

Jul 27, 2011, 3:41:57 PM7/27/11

to

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

unread,

Jul 27, 2011, 4:09:10 PM7/27/11

to

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

unread,

Jul 28, 2011, 3:58:07 PM7/28/11

to

> 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

unread,

Jul 28, 2011, 8:14:55 PM7/28/11

to

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

unread,

Jul 28, 2011, 10:55:50 PM7/28/11

to

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

Jim Cone

unread,

Jul 29, 2011, 1:58:29 PM7/29/11

to

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" <rick.new...@NO.SPAMverizon.net>
wrote in message
news:j0t7fl$9m5$1...@dont-email.me...

Rick Rothstein

unread,

Jul 29, 2011, 2:48:04 PM7/29/11

to

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

Jim Cone

unread,

Jul 29, 2011, 3:10:14 PM7/29/11

to

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

"Rick Rothstein" <rick.new...@NO.SPAMverizon.net>
wrote in message

news:j0uv93$u7a$1...@dont-email.me...

DCJM

unread,

Aug 25, 2011, 6:05:18 AM8/25/11

to

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

"Jim Cone" <james....@comcast.netXxx> wrote in message
news:j0v0ir$84e$1...@dont-email.me...