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,