Excel.ConditionalColorScaleCriterion interface

Represents a color scale criterion which contains a type, value, and a color.

Remarks

color	HTML color code representation of the color scale color (e.g., #FF0000 represents Red).
formula	A number, a formula, or `null` (if `type` is `lowestValue`).
type	What the criterion conditional formula should be based on.

HTML color code representation of the color scale color (e.g., #FF0000 represents Red).

color?: string;

string

A number, a formula, or null (if type is lowestValue).

formula?: string;

string

What the criterion conditional formula should be based on.

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