Color Property

Official Content
This documentation is valid for:

This property is used to specify:

  • the color of the cells (excel cells).
  • the color in the rules (transactions and work panels).

Syntax (in runtime for Excel Cells)

&ExcelDocument.Cells(…).Color
&ExcelBorderStyle.Color
&excelFont.Color

Type Returned:
Numeric

Values

In runtime for Excel cells

Positive Value: The Excel color index number corresponding to the number indicated will be taken as the value. Ref. https://docs.microsoft.com/en-us/office/vba/api/Excel.ColorIndex
Negative Value (except –1): The color number in the RGB scheme corresponding to the absolute number indicated will be the value taken (i.e.: as a value returned by the RGB function).
-1: The default color defined by Excel will be taken.

For ExcelSpreadSheet data type methods return a ExcelColor data type

In the Color property for transactions and work panels.

Default to color rule: specify the default value specified in the Options command menu.
Any other color of the possibles.

Description

If there are cells with different colors in the ExcelCells object, this property will return a 0.

Scope

Extended Data Types: ExcelCells,ExcelBorderStyle data typeExcelFont Data Type Transactions, Work Panels
Languages: .NET, Java

See Also

Cells Method
ExcelCells Data Type
ExcelDocument Data Type
ExcelSpreadSheet data type
Styles tab in the Editors configurations