How to change Excel Color Palette using VBA
You can download a sample worksheet with the Excel Color Index and Palette with VBA code here or click on the button below: One would think that the simplest way for anyone to create the palette would have been to number the colors in some logical fashion so that those colors could be modified using a program far more easily than by having to remember the position of each individual color in the palette. The interesting thing is that there seems to be no apparent logic to the allocation of color index values to various colors – it neither proceeds from light (#FFFFFF) to dark (#000000) or follow a sequential numbering pattern in the palette (left to right or up to down). However you cannot change those color values in the palette which would lead me to assume that Excel provides 58 (56 + 2) assignable color values while there being only 56 modifiable color values.) (Please note: Values -1 and 0 can be assigned to an object. The output of the code will be something akin to what is shown below. 'Excel shows nibbles in reverse order so make it as RGB
