.Color versus .ColorIndex

Excel 2007 seems to like .color "better" than .colorindex which I'm used to in xl 2002.

I know that the color #'s in xl 2007 have changed.

My context is .Font.????

MSo help is not helpful on what the differences , pro or con,  are

over using .Color or .ColorIndex,  What are they?


  Neal Z


Question Info

Last updated April 28, 2019 Views 2,425 Applies to:

colorindex uses a color palette with an index number to select the color from the palette

example, 49 = Blue (or one of the blues):

font.colorindex = 49  

color uses the RGB properties and has millions of combinations you can pick

RGB(256, 0, 0) = Red

RGB(0, 256, 0) = Green

RGB(0, 0, 256) = Blue


font.colorindex = RGB(0,0,256)

Good Luck

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.