I know how to change the color palette. The problem is: changes do not
stick if I open the workbook on a different computer. I am working with
a macro and would like to use something like
ColorIndex(3)=RGB(207,254,255) to set some soft pastel colors. Is there
a way to do this?

Incidently, while trying to do this I discovered that the color palette
makes no sense at all! There is no relationship between the ColorIndex
and the position on the chart or the color spectrum. One wonders what
logic process was used to develop this chart in which index numbers
range from 1 - 56, but 17-32 are missing. And if you customize a color,
the color changes but the index number stays the same. Go figure!

kaldon