VBA: Color Reference For Colorindex

When using VBA to code the Colorindex (or background color) of a cell it is useful to know what integer will equal what color. Below is a reference picture which shows the color and lists it’s respective Colorindex. aka VBA Color Palette

excel color references

Here’s the code to make one for yourself, or just bookmark the permalink:

One Comment

  1. Britt November 11, 2016 at 11:35 pm - Reply

    How can I have a function that selects cells with a certain color.index? something like- Set WorkingRange = WorkingRnage.Interior.ColorIndex = 38 or something?

Leave A Comment