ExcelScript.ConditionalFormatRule interface

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

Methods

getFormula()

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

getFormulaLocal()

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

setFormula(formula)

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

setFormulaLocal(formulaLocal)

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

Method Details

getFormula()

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

getFormula(): string;

Returns

string

getFormulaLocal()

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

getFormulaLocal(): string;

Returns

string

setFormula(formula)

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

setFormula(formula: string): void;

Parameters

formula

string

Returns

void

setFormulaLocal(formulaLocal)

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

setFormulaLocal(formulaLocal: string): void;

Parameters

formulaLocal

string

Returns

void