Exposes properties which displays icons in a [[WorksheetCell]] based on the cell's value as relative to threshold values.

Constructors

Section titled "Constructors"

IconSetConditionalFormat 

new IconSetConditionalFormat(a: number): IconSetConditionalFormat

Returns IconSetConditionalFormat

Properties

Section titled "Properties"

$t

Section titled "$t" 
$t: Type

Accessors

Section titled "Accessors"

conditionType

Section titled "conditionType"

Inherited from: ThresholdConditionBase

Returns a [[FormatConditionType]] value which identifies the type of condition for this instance.

 
get conditionType(): FormatConditionType

Returns FormatConditionType

formula

Section titled "formula"

Inherited from: ThresholdConditionBase

Returns the formula which determines the values to which this condition applies. Note: the formula should return a boolean result. When the formula is applied to cells in the region if the formula returns false then those cells will not be included in the formatting.

 
get formula(): Formula

Returns Formula

iconSet

Section titled "iconSet"

Returns or sets a [[FormatConditionIconSet]] value which identifies the set of icons used to express this condition.

 
get iconSet(): FormatConditionIconSet

Returns FormatConditionIconSet 

set iconSet(a: FormatConditionIconSet): void

Parameters

Returns void

isCustom

Section titled "isCustom"

Returns true if the Icon property of one or more criterion returns a value which is from a different icon set as the one returned from the [[iconSet]] property.

 
get isCustom(): boolean

Returns boolean

isReverseOrder

Section titled "isReverseOrder"

Returns or sets a boolean value indicating whether the order in which icons appear is reversed.

 
get isReverseOrder(): boolean

Returns boolean 

set isReverseOrder(a: boolean): void

Parameters

  • a: boolean

Returns void

priority

Section titled "priority"

Inherited from: ThresholdConditionBase

Returns or sets a value which determines the order of evaluation when multiple conditional formatting rules exist.

 
get priority(): number

Returns number 

set priority(a: number): void

Parameters

  • a: number

Returns void

regions

Section titled "regions"

Inherited from: ThresholdConditionBase

Returns the [[WorksheetRegion]] which identifies the cell range with which this condition is associated.

 
get regions(): ReadOnlyCollection$1<WorksheetRegion>

Returns ReadOnlyCollection$1<WorksheetRegion>

showValue

Section titled "showValue"

Returns or sets a boolean value indicating whether the cell value is shown along with the icon.

 
get showValue(): boolean

Returns boolean 

set showValue(a: boolean): void

Parameters

  • a: boolean

Returns void

stopIfTrue

Section titled "stopIfTrue"

Inherited from: ThresholdConditionBase

Returns or sets a boolean indicating whether additional formatting rules are evaluated if this rule evaluates to true. Applicable only in the case where the containing collection contains more than one element.

 
get stopIfTrue(): boolean

Returns boolean 

set stopIfTrue(a: boolean): void

Parameters

  • a: boolean

Returns void

workbook

Section titled "workbook"

Inherited from: ThresholdConditionBase

Returns a reference to the associated workbook.

 
get workbook(): Workbook

Returns Workbook

worksheet

Section titled "worksheet"

Inherited from: ThresholdConditionBase

Returns a reference to the associated worksheet.

 
get worksheet(): Worksheet

Returns Worksheet

Methods

Section titled "Methods"

iconCriteria

Section titled "iconCriteria"

Returns the [[IconCriterion]] object corresponding to the specified 'index'.

 
iconCriteria(index: number): IconCriterion

Parameters

  • index: number

    A zero-based index.

Returns IconCriterion

setFirstPriority

Section titled "setFirstPriority"

Inherited from: ThresholdConditionBase

Sets the [[priority]] value for this rule such that it is the first condition to be evaluated. Applicable only in the case where there is more than one element contained within the associated collection.

 
setFirstPriority(): void

Returns void

setFormula

Section titled "setFormula"

Inherited from: ThresholdConditionBase

Assigns a new [[Formula]] to the [[formula]] property. Note: the formula should return a boolean result. When the formula is applied to cells in the region if the formula returns false then those cells will not be included in the formatting.

 
setFormula(formula: string, cellReferenceMode: CellReferenceMode): void

Parameters

  • formula: string

    The string representation of the formula.
  • cellReferenceMode: CellReferenceMode

    A [[CellReferenceMode]] value which specifies whether the 'formula' parameter should be interpreted as an A1 or R1C1 expression. This parameter is optional and defaults to null, in which case the [[Workbook.cellReferenceMode]] property is used.

Returns void

setLastPriority

Section titled "setLastPriority"

Inherited from: ThresholdConditionBase

Sets the [[priority]] value for this rule such that it is the last condition to be evaluated. Applicable only in the case where there is more than one element contained within the associated [[ConditionalFormatCollection]].

 
setLastPriority(): void

Returns void

setRegions

Section titled "setRegions"

Inherited from: ThresholdConditionBase

Replaces the existing regions with new ones

 
setRegions(regionAddress: string, cellReferenceMode: CellReferenceMode | null): void

Parameters

  • regionAddress: string

    A string with one or more comma separated region address
  • cellReferenceMode: CellReferenceMode | null

    An optional cell reference mode

Returns void

staticInit

Section titled "staticInit" 
staticInit(): void

Returns void