Excel.ConditionalDataBarRule interface

Represents a rule-type for a data bar.

Remarks

[ API set: ExcelApi 1.6 ]

Properties

formula

The formula, if required, on which to evaluate the data bar rule.

type

The type of rule for the data bar.

Property Details

formula

The formula, if required, on which to evaluate the data bar rule.

formula?: string;

Property Value

string

Remarks

[ API set: ExcelApi 1.6 ]

type

The type of rule for the data bar.

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

Property Value

Excel.ConditionalFormatRuleType | "Invalid" | "Automatic" | "LowestValue" | "HighestValue" | "Number" | "Percent" | "Formula" | "Percentile"

Remarks

[ API set: ExcelApi 1.6 ]