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

  • Thread starter Thread starter Mark
  • Start date Start date
M

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,
 
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.
 
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,
 
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.
 
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
 
Back
Top