Find Closest Color

[TheSpriceEffect]

I have a range of cells in sheet 1 which have a few basic colors. And in sheet 2, I have a button that converts an image to colored cells using pixel colors. After using said button, sheet 2 is filled with a bunch of random colors. Now I am wondering if I can create a sub which takes a cell in sheet 2 and converts it to the most similar color of the range in sheet 1. The problem is, I don't think I can use the color index, because I don't see any correlation between the color index number and the color it represents.

[clabhart]

Here is a link to a website which list the color index and what number represents which color. http://dmcritchie.mvps.org/excel/colors.htm

[mikerickson]

I'm not sure what you are doing, but you might want to look at this. (Unfortuantly the old Colors collection has been replaced)

Please Login or Register  to view this content.