How to change the default interior color palette index in Excel 2003

T

tenten0925

I want to use the command

Cells(i, j).Interior.ColorIndex = 50

to fill the cell with color I want.

In Excel, it has its default index palette for Interior Color.

How can I customized its index or even change the color in each index
number?

Coz the default index palette doesn't match with the palette under
Tools ---> Options ----> Color

Any one can help on this???

MICTEN
 

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