Color property

Returns or sets the color of the font. Use the RGB function to create a color value. Read/write Longword.

Setting Color on the BIFF8 path writes the exact RGB through the XFExt $087D rich-color side record (Excel 2007+ reopens the workbook with the literal RGB) and a best-match indexed icv on the XF wire (Excel 97-2003 readers see the 56-color palette approximation). The reader consults the XFExt side-table too, so font colors round-trip through HotXLS without falling back to the palette approximation.

For theme-based addressing use the companion SetThemeColor method, which encodes an Office theme idx + tint into the same XFExt slot so Excel re-tints the text when the workbook theme palette changes. See Classic XLS color model for the overall RGB / index / theme decision tree.

Workbook.Worksheets[1].Range['A1', 'A1'].Font.Color := RGB(255, 0, 0);