Excel.Interfaces.ConditionalFormatRuleUpdateData interface

An interface for updating data on the ConditionalFormatRule object, for use in conditionalFormatRule.set({ ... }).

Properties

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

formula

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

formula?: string;

Property Value

string

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?: string;

Property Value

string

Remarks

[ API set: ExcelApi 1.6 ]

formulaR1C1

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

formulaR1C1?: string;

Property Value

string

Remarks

[ API set: ExcelApi 1.6 ]