Excel.Interfaces.ConditionalFormatRuleLoadOptions interface

Represents a rule, for all traditional rule/format pairings.

Remarks

[ API set: ExcelApi 1.6 ]

Properties

$all

Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as Range.format.fill.color).

formula

The formula, if required, on which to evaluate the conditional format rule.

formulaLocal

The formula, if required, on which to evaluate the conditional format rule in the user's language.

formulaR1C1

The formula, if required, on which to evaluate the conditional format rule in R1C1-style notation.

Property Details

$all

Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as Range.format.fill.color).

$all?: boolean;

Property Value

boolean

formula

The formula, if required, on which to evaluate the conditional format rule.

formula?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.6 ]

formulaLocal

The formula, if required, on which to evaluate the conditional format rule in the user's language.

formulaLocal?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.6 ]

formulaR1C1

The formula, if required, on which to evaluate the conditional format rule in R1C1-style notation.

formulaR1C1?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.6 ]