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

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How to change the default interior color palette index in Excel 2003 (https://www.excelbanter.com/excel-programming/386411-how-change-default-interior-color-palette-index-excel-2003-a.html)

[email protected]

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

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

Barb Reinhardt

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

This should help.

" wrote:

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

All times are GMT +1. The time now is 09:43 AM.