Taietel, thanks for the reply.
The pdf is a quite good reading and gives a lot of information what color to use for which purpose.
Where I need information is how to use the COM objects, methods and properties.Color
: lets you specify the color as red, green, blue valuesColorIndex
: lets you specify the color as a number from 0-56 of the current color palette.SchemeColor
: When I want to color a fill I have to use SchemeColor (values from 0-56) but it seems to use a different color palette because I get different colors compared to ColorIndex.
So I need a good reading explaining how to use the different methods and properties. It should explain Excel 2007 and Excel 2010.
Edited by water, 22 March 2013 - 11:39 PM.