"iColor" and "ColorIndex" in vba

Hello All,

The following vba code operates as designed, i.e., it randomly assigns fill colors by row based on criteria changes in Column C of my data set. That’s what I want. However, I’m seeing that some of the fill colors are much too dark which causes the text to be almost unreadable. I did some research, and it looks to me that there is a 56-color palette and a 256-color palette.

1. Is it possible to select my own specific array of palette colors, mostly in pastels, by inserting specific color numbers in the vba code? As in “iColor” or “ColorIndex” (I don’t know the difference). For example, light magenta has a hexadecimal value of #FF99CC and an RGB sequence of R=255; G=153; B=204. (I might choose eight or so LIGHTER FILL color choices)

2. Assuming this is possible, be kind enough to supply concise and detailed instructions as my vba skills are limited to using not constructing code.

Thanks,

Bill in Denver

Please Login or Register  to view this content.

Welcome to the forum.

Except for Excel 2007, you have a 56-color palette. You can change the colors via Tools > Options > Color.

Hello bill_in_denver,

Here are a couple of links you may find useful...

How to Display Any Color in Excel

How to Change the Color Palette for Excel Workbooks