Shading cells - how to pick a slight/different shade of a color

[Mark]

I am using the grey shade on cells. However, in some instances the dark grey
is ok, in other instances I would like to use a lighter grey. I do not see
where you can go to advance options to either use RGB coding or modify the
colors in the palette.

Thanks,

 

[Rick Rothstein]

You can change the indexed colors by clicking on Tools/Options on Excel's
menu bar, selecting the Color tab, clicking a color you want to change in
the grid of colors, then clicking the Modify button, then pick either an
existing "Standard" color or a "Custom" color via the tabs at the top of the
dialog box.

 

[Mark]

First, thanks for the quick response.

I followed your instructions. What happened was that the new shade I
selected actually replaced the one being edited. It automatically changed
the shading in my excel sheet.

Is there a way to modify an existing shade, but add the new shade as being a
new color to choose?

Thanks,

 

[T. Valko]

You must be using a version of Excel prior to Excel 2007...

You can have only a set number of colors. If you want a new color it must
replace one of the current colors. The best way to do this is to replace one
of the colors that you will/would never use.

 

[Gord Dibben]

Excel is limited to 56 colors.

If you modify one then the original is gone.

Only way to apply an additional color to a cell would be through VBA using
RGB numbers.

Or pick some color that you would never use and modify it.

Lavender or Rose come to mind as colors I would never employ.

Make one of those your new gray color.


Gord Dibben MS Excel MVP