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