Returns or sets the color of the interior. The color is specified as an index value into the current color palette, or as one of the XlColorIndex constants. Read/write LongWord.
Syntax
property ColorIndex: LongWord;
Description
ColorIndex can be one of these XlColorIndex constants.
| xlColorIndexAutomatic |
Use to specify the automatic fill |
| xlColorIndexNone |
Use to specify no interior fill |
The following illustration shows the color-index values in the default color palette.
Example
This example sets the color of the range A1:C10 interior to red.
Workbook.Worksheets[1].Range['A1', 'C10'].Interior.ColorIndex := 3;