Color Property

[jonpyne]

Hi, there
Can anyone explain the point of the Color property? ColorIndex allows you to assign a colour from the palette. Color allows you to assign an RGB value. That's what it says on the tin. That is the code in a myriad of examples all over the internet: MyCell.Interior.Color = RGB(130, 195, 130). BUT IT DOES NOT DO THAT, does it! It snaps to the closest equivalent it can find in the palette. So what is the point?
My scenario was simple. I wanted a chart to be a certain colour, whatever the user did with the palette. Color looked to be the answer. Is there actually a way to do this?
Thanks for looking.
Jon
MS Excel 2003.

 

[Andrew Poulsom]

Excel is limited to the 56 colours in the palette, which you can modify.

 

[jonpyne]

Thanks, Andrew. I guess that's that, then.
I'm still baffled why they have the read/write property, though. It is as though they never got round to finishing it. You can assign it a value, but it will not be used.

 

[RoryA]

it will be used, if it can be (and in 2007 and later it can be) but it also means you can get whatever colour is closest to, say, red without having to know the colorindex for whatever colour palette is in use.