ColorIndex

[Zzzzzz]

Can someone provide me with, or point me in the right direction, to find out which value = which color i.e. 3 = red etc?

Just found the answer
http://www.mvps.org/dmcritchie/excel/colors.htm
Thanks

 

[RalphA]

Say, Zzzzzz, that is a great sie! Just copied the Web address to my special Excel "Answers.xls" file! Thanks for posting it and letting us all know about it!!!

 

[Zzzzzz]

Say, Zzzzzz, that is a great sie! Just copied the Web address to my special Excel "Answers.xls" file! Thanks for posting it and letting us all know about it!!!

No problem Ralph!

I am happy that I can finally contribute something to this resource, as due to my lack of VBA understanding, I mostly just take!

 

[RalphA]

I'm fairly good in BASIC and QuickBASIC, and moderately good in Visual Basic, but, when I ran into VBA, I gave up! It's just too complicated for me, in general. My speed is to use the Tools, Macro, Record a macro, then use it. But, VBA's syntax confuses me no end, to the point that I decided not to complicate my life, and simple ignore VBA!