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

's Computer Specifications

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

's Computer Specifications

This should help.

"(E-Mail Removed)" 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
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using VBA to change default color palette	Garyc	Microsoft Excel Programming	1	23rd Jan 2010 10:43 AM
Why the change in default color palette in Word 2007?	leogal1006	Microsoft Word Document Management	1	22nd Dec 2009 10:57 PM
How can I change the 2007 color palette to the 2003 color palette	linnius	Microsoft Powerpoint	1	25th Jan 2009 03:17 AM
Why does the default Excel color palette change between workbooks	ajkajkajk	Microsoft Excel Misc	1	18th Dec 2008 06:05 PM
How to change the Word default color palette?	=?Utf-8?B?Q2hlcnls?=	Microsoft Word Document Management	4	31st Aug 2006 05:26 PM