Excel VBA Interior.ColorIndex issue

[jdc2000]

I have a question for any Excel guru who may know the answer, regarding Interior.ColorIndex values.

If I change a cell background color to the Green that is available from the Excel Ribbon color selector, and then use VBA to get the ColorIndex value, it returns 14. However, if I set a cell Interior.ColorIndex value to 14, I do NOT get the same shade of Green. An index value of 10 is closer, but still not quite the same. If anyone can explain why the returned value will not generate the same color when used to set another cell, or if anyone knows what index value to use to get the same Green that I can select manually, that information would be most helpful. Note also that Red and Yellow do not have this issue.

Links I have found:

http://dmcritchie.mvps.org/excel/colors.htm

https://www.excelmojo.com/colorindex-vs-color-in-vba/

https://www.reddit.com/r/excel/comme...for_different/

https://www.reddit.com/r/excel/comme...a_color_in_ms/

https://stackoverflow.com/questions/...hat-is-visible


Thanks.

[jdc2000]

After some research, it appears that the solution to this issue would be to use the Interior.Color property instead of the Interior.ColorIndex property. That appears to work correctly.