ExcelScript.ConditionalColorScaleCriterion interface

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

Properties

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: ConditionalFormatColorCriterionType;