Exposes properties which control the visual attributes of a [[WorksheetCell]] based on whether the cell's value meets the criteria defined by a logical operator.

Constructors

Section titled "Constructors"

OperatorConditionalFormat 

new OperatorConditionalFormat(a: number): OperatorConditionalFormat

Returns OperatorConditionalFormat

Properties

Section titled "Properties"

$t

Section titled "$t" 
$t: Type

Accessors

Section titled "Accessors"

cellFormat

Section titled "cellFormat"

Inherited from: ConditionalFormatBase

Returns an [[IWorksheetCellFormat]] interface implementation which represents the format for cells which meet the criteria associated with this condition.

 
get cellFormat(): IWorksheetCellFormat

Returns IWorksheetCellFormat

conditionType

Section titled "conditionType"

Inherited from: ConditionalFormatBase

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

 
get conditionType(): FormatConditionType

Returns FormatConditionType

operand1

Section titled "operand1"

Returns the formula which defines the criteria for the first operand of this condition.

 
get operand1(): Formula

Returns Formula

operand2

Section titled "operand2"

Returns or sets a formula for the second operand which defines the criteria for this condition when the [[operator]] property is set to Between or NotBetween

 
get operand2(): Formula

Returns Formula

operator

Section titled "operator"

Returns a [[FormatConditionOperator]] constant which determines the manner in which the cell value is compared against the [[operand1]] property.

 
get operator(): FormatConditionOperator

Returns FormatConditionOperator 

set operator(a: FormatConditionOperator): void

Parameters

Returns void

priority

Section titled "priority"

Inherited from: ConditionalFormatBase

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: ConditionalFormatBase

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

 
get regions(): ReadOnlyCollection$1<WorksheetRegion>

Returns ReadOnlyCollection$1<WorksheetRegion>

stopIfTrue

Section titled "stopIfTrue"

Inherited from: ConditionalFormatBase

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: ConditionalFormatBase

Returns a reference to the associated workbook.

 
get workbook(): Workbook

Returns Workbook

worksheet

Section titled "worksheet"

Inherited from: ConditionalFormatBase

Returns a reference to the associated worksheet.

 
get worksheet(): Worksheet

Returns Worksheet

Methods

Section titled "Methods"

setFirstPriority

Section titled "setFirstPriority"

Inherited from: ConditionalFormatBase

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

setLastPriority

Section titled "setLastPriority"

Inherited from: ConditionalFormatBase

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

setOperand1

Section titled "setOperand1"

Assigns the specified System.DateTime value to the [[operand1]] property.

 
setOperand1(value: Date): void

Parameters

  • value: Date

    The System.DateTime value to assign.

Returns void

setOperand1Formula

Section titled "setOperand1Formula"

Assigns a [[Formula]] to the [[operand1]] property.

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

Parameters

  • formula: string

    The string representation of the [[Formula]] to be assigned to the [[operand1]] property.
  • 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

setOperand2

Section titled "setOperand2"

Assigns the specified System.DateTime value to the [[operand2]] property.

 
setOperand2(value: Date): void

Parameters

  • value: Date

    The System.DateTime value to assign.

Returns void

setOperand2Formula

Section titled "setOperand2Formula"

Assigns a [[Formula]] to the [[operand2]] property.

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

Parameters

  • formula: string

    The string representation of the [[Formula]] to be assigned to the [[operand2]] property.
  • 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

setRegions

Section titled "setRegions"

Inherited from: ConditionalFormatBase

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"

Inherited from: ConditionalFormatBase 

staticInit(): void

Returns void