Hi all,

Sorry if this isn't a VBA question, but i can't seem to find a way to make it work without it. I would like to restrict the color palette of my workbook to about 7 or 8 colors. Some of these colors are in the 56 color index, and some have RGB values outside the standard index of 56. I've got several subs running in my workbook pulling information based on cell color, and they are contingent upon the fill colors of my table staying consistent. Others will be updating these fill colors regularly, so I don't want a simple error like a slightly different shade of a color to mess up my sub results.

I would appreciate any help.