Docs HotXLS

ColorIndex-property

Renvoie or sets the color of the border. The color is specified as an index value into the current color palette, or as one of the following XlColorIndex constants. Read/write LongWord

Syntaxe

property ColorIndex: LongWord;

Description

ColorIndex can be one of these XlColorIndex constants
xlColorIndexAutomatic Use to specify the automatic border color
xlColorIndexNone Use to specify no border color

Exemple

This example sets the color of the top edge border of A1:D1 range

Workbook.Sheets[1].Range['A1', 'D1'].Borders[xlEdgeTop].ColorIndex := 5;