Custom shading colors
 

Excel only displays 56 colors on a cell background. As you said, there are
tied to the colorindex. If the user redefines the RGB value of the color
index, then that will change the color displayed. The palette is retained
with the workbook. All this pretty much echos what you have observed - just
confirming it. You really have not control over this other than running a
macro that sets the palette back to what you want it to be. You can get
code for doing this by turning on the macro recorder while you modify the
palette manually.

http://www.mvps.org/dmcritchie/excel/colors.htm
David McRitchie's Page on Color and Excel

http://www.cpearson.com/excel/colors.htm
Chip Pearson's Functions for Cell Colors Page

--
Regards,
Tom Ogilvy

"pk" wrote in message
...
I hope someone can help me out on this one please!

I mixed a few new colors using RGB that I want applied to
certain cells on a spreadsheet that will be shared among
many users.

The problem is, I noticed that setting RGB only changes
the color pallette and if the user resets or changes their
color pallette, then MY colors are all reset on the
spreadsheet (and they look bad!) to THEIR settings.

Apparently its all linked by the color index? i.e. If the
user changes their color index, that change updates the
spreadsheet color.

Is there is foolproof (or at least better) way of applying
custom shading to certain cells in a spreadsheet that will
be more stable (i.e. less changeable)???

Your example code would be most helpful. Thanks in advance
to all who respond...