Changing Color Palette

K

kaldon

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
 
C

Chip Pearson

Use code like

ThisWorkbook.Colors(3) = RGB(207,254,255)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top