Excel.ConditionalIconCriterion interface

Package:

excel

Represents an icon criterion which contains a type, value, an operator, and an optional custom icon, if not using an icon set.

Remarks

[Api set: ExcelApi 1.6]

Properties

customIcon	The custom icon for the current criterion, if different from the default icon set, else null will be returned.
formula	A number or a formula depending on the type.
operator	greaterThan or greaterThanOrEqual for each of the rule types for the icon conditional format.
type	What the icon conditional formula should be based on.

Property Details

customIcon

The custom icon for the current criterion, if different from the default icon set, else null will be returned.

customIcon?: Excel.Icon;

Property Value

Excel.Icon

Remarks

[Api set: ExcelApi 1.6]

formula

A number or a formula depending on the type.

formula: string;

Property Value

string

Remarks

[Api set: ExcelApi 1.6]

operator

greaterThan or greaterThanOrEqual for each of the rule types for the icon conditional format.

operator: Excel.ConditionalIconCriterionOperator | "Invalid" | "GreaterThan" | "GreaterThanOrEqual";

Property Value

Excel.ConditionalIconCriterionOperator | "Invalid" | "GreaterThan" | "GreaterThanOrEqual"

Remarks

[Api set: ExcelApi 1.6]

type

What the icon conditional formula should be based on.

type: Excel.ConditionalFormatIconRuleType | "Invalid" | "Number" | "Percent" | "Formula" | "Percentile";

Property Value

Excel.ConditionalFormatIconRuleType | "Invalid" | "Number" | "Percent" | "Formula" | "Percentile"

Remarks

[Api set: ExcelApi 1.6]