Returns or sets the cell shading colour of the range. Use the
RGB function to create a colour value. Read/write LongWord.
Setting Color on the BIFF8 path writes the exact RGB through the XFExt $087D rich-colour side record (Excel 2007+ reopens the workbook with the literal RGB) and a best-match indexed icv on the XF wire (legacy Excel 97-2003 readers see the 56-colour palette approximation). The XFExt side-table is also consulted on read, so cells coming back in from Excel surface their original RGB rather than the palette approximation.
For theme-based addressing use the companion
SetThemeColor /
SetPatternThemeColor methods, which encode an Office theme idx + tint into the same XFExt slot so Excel re-tints the cell when the workbook theme palette changes. See
Classic XLS colour model for the overall RGB / index / theme decision tree.
Syntax
property Colour: LongWord;
Example
This example sets the colour of the range A1:C10 interior to red.
Workbook.Worksheets[1].Range['A1', 'C10'].Interior.Color := xlRed;