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

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,
--
Mark

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

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.

--
Rick (MVP - Excel)


"Mark" wrote in message
...
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,
--
Mark

Shading cells - follow up
 

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,
--
Mark


"Rick Rothstein" wrote:

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.

--
Rick (MVP - Excel)


"Mark" wrote in message
...
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,
--
Mark

Shading cells - follow up
 

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.

--
Biff
Microsoft Excel MVP


"Mark" wrote in message
...
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,
--
Mark


"Rick Rothstein" wrote:

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.

--
Rick (MVP - Excel)


"Mark" wrote in message
...
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,
--
Mark

Shading cells - follow up
 

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


On Thu, 1 Jan 2009 12:35:01 -0800, Mark
wrote:

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,