How excel identifies ColorIndex

[Raju Gupta]

Hi,


How excel identifies ColorIndex. i.e if I pass number 16 to ColorIndex what color it displays and how it manipulates that number.


Regards

 

[NARAYANK991]

Hi Raju ,


The following link gives a lot of information ; hope it helps.


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


Narayan

 

[Raju Gupta]

Hi Narayan,


thank you

 

[Raju Gupta]

Hi,


what color does it get with "Series(i).Format.Fill.ForeColor.ObjectThemeColor = 5 "

 

[NARAYANK991]

Hi Raju ,


I tried with the following statement :


Activechart.SeriesCollection(1).Format.Fill.ForeColor.ObjectThemeColor = 5


and I got the default sky-blue colour.


You can use numbers from 1 through 12 , 1 standing for black , 2 for white and so on.


Narayan

 

[Raju Gupta]

Hi Narayan,


thank you

 

[CorrieAnn Gillen]

This post is a little dated. I need color index codes for 2013 as there are new/updated colors. I am using a color pretty close to 37 in the older charts, but I can't seem to find a 2013 chart anywhere. Does anyone know where I can get this info?

 

[bobhc]

You have buried your question in a post that is well over two years old, those who have looked at this post title may not re-look as they will think there is nothing they can add so you are restricting your chances of help.
A new post with your question may bring a better response.

http://msdn.microsoft.com/en-us/library/office/ff840443(v=office.15).aspx

http://www.officewriter.com/blog/2013/05/08/excels-color-palette-explained

.

 

[aloofmuse]

Hi! Please help. How do you change the sheet tab color of excel spreadsheets?

 

[Somendra Misra]

Hi aloofmuse,

Right Click on the tab, from the menu select Tab colour and choose the colour. See the image below.



Regards,