Represents the aggregated conditioal format for a specific cell. It is returned via the Worksheet.GetCellConditionalFormat and the WorksheetRow.GetCellConditionalFormat methods.

CellConditionalFormat

new CellConditionalFormat(a: number): CellConditionalFormat

Returns CellConditionalFormat

$t: Type

Returns a cell format that represents the aggregated format for all conditional formats that apply to the cell (read-only).

get cellFormat(): IWorksheetCellFormat

Returns IWorksheetCellFormat

Returns a data bar info if applicable, otherwise null (read-only).

get dataBarInfo(): CellDataBarInfo

Returns CellDataBarInfo

Returns whether this cell has conditional formatting applied (read-only)

get hasConditionFormatting(): boolean

Returns boolean

Returns an icon info if applicable, otherwise null (read-only).

get iconInfo(): CellIconInfo

Returns CellIconInfo