FormatCondition.SetFormula1

FormatCondition.SetFormula1 method

Sets the value or expression associated with this format condition.

public void SetFormula1(string formula, bool isR1C1, bool isLocal)
ParameterTypeDescription
formulaStringThe value or expression associated with this format condition. If the input value starts with ‘=’, then it will be taken as formula. Otherwise it will be taken as plain value(text, number, bool). For text value that starts with ‘=’, user may input it as formula in format: “="=…"”.
isR1C1BooleanWhether the formula is R1C1 formula.
isLocalBooleanWhether the formula is locale formatted.

See Also