View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default 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