Returns 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.
Syntax
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 |
Example
This example sets the color of the top edge border of A1:D1 range.
Workbook.Sheets[1].Range['A1', 'D1'].Borders[xlEdgeTop].ColorIndex := 5;