Cell Highlight color

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

I am working in an Excel Spreadsheet.

I would like the color of the highlighted area to be a
different color than what I have now.

This change should only effect Excel.

Thanks

Scott
 
Hi Scott,
Change the color yellow on you color palette, by swapping the color
with another. I don't think you will be happy with the results.
Write down the RGB colors so you can properly swap two colors,
they yellow and probably the "Light Green"

Tools, Options, Color (tab)
select yellow swatch, custom, modify RGB values 255, 255, 0
change it to 204, 255, 204
select "Light Green" it should show as 204, 255, 204
change it to 255, 255, 0

I expect you won't like it after about 20 minutes, and if you are in
an office. Tell us how many days it lasted.

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
 
Hi Scott
this color is a Windows Setting. So you can't change it just for Excel
alone
 
Frank,

Thanks for the reply.

It seems that they made it simple for themselves. That is
MS.

Although in all my years of working in this field this is
the first time I have been asked to change this feature.

Scott
 
Hi Scott,
I don't know what I was thinking about for yellow. You were talking about
the color for selected cells. I knew it wasn't making sense and that it affected
all of windows and I was saying change the color palette which only
changes one workbook. Ok so back on track. My Excel is 2000
and I think that is where the colored selection began in Excel.

The color used for selection is not one of the colors in the Color Palette
the color of the selection is RGB(169, 178, 202)
If you assign that color to a cell, then Excel will approximate it to
what it thinks is the closest color RGB(192, 192, 192) which is
a gray and distinctly different. from the selection color.

The fact that it doesn't match any color in the color palette helps to
make it possible to distinguish characters even when selected.

As Frank said it will affect all of Windows and Office for selections
selecting something in HTML, selecting something from Windows Start,
selecting something in notepad, selecting from any list such as filenames,
drop downs, and of course selecting cells that you wanted.

Settings, Control Panel, Display,.
on scheme type in your name and date -- Scott-2004-03-31-Current
then Save As,
now you have saved your current scheme which is probably the default
that you started with but you would have a hard time identifying you
are actually using unless you name it yourself, now you have a permanent
scheme to fall back to...

Next type in your name and date and test i.e. Scott-2004-03-31-test
and once again use Save As,
Then within item: select Selection and then choose your color , then apply.

To get back to what you had simply go back to your last scheme
Scott-2004-03-31-current you can always fall back to this.

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
 
couple of corrections in wording:

left out the word appearance in
Settings, Control Panel, Display,. Appearance

you would have a hard time identifying *what you were*
actually using *unless you name a scheme* yourself, now you
have a permanent scheme to fall back to...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top