Excel.ConditionalColorScaleCriterion interface

Represents a Color Scale Criterion which contains a type, value, and a color.

[ API set: ExcelApi 1.6 ]

Properties

color

HTML color code representation of the color scale color. E.g. #FF0000 represents Red.

[ API set: ExcelApi 1.6 ]

formula

A number, a formula, or null (if Type is LowestValue).

[ API set: ExcelApi 1.6 ]

type

What the icon conditional formula should be based on.

[ API set: ExcelApi 1.6 ]

Property Details

color

HTML color code representation of the color scale color. E.g. #FF0000 represents Red.

[ API set: ExcelApi 1.6 ]

color?: string;
Property Value
string

formula

A number, a formula, or null (if Type is LowestValue).

[ API set: ExcelApi 1.6 ]

formula?: string;
Property Value
string

type

What the icon conditional formula should be based on.

[ API set: ExcelApi 1.6 ]

type: Excel.ConditionalFormatColorCriterionType | "Invalid" | "LowestValue" | "HighestValue" | "Number" | "Percent" | "Formula" | "Percentile";
Property Value
Excel.ConditionalFormatColorCriterionType | "Invalid" | "LowestValue" | "HighestValue" | "Number" | "Percent" | "Formula" | "Percentile"