3.2.3.1.2 Conditional Formatting Formulas

  • Article

Conditional formatting formulas are part of conditional formatting rules.

A conditional formatting formula shall not use array constants.

A conditional formatting formula shall not use structure references.

A conditional formatting formula shall not use union and intersection binary operators.

A conditional formatting formula shall not use 3-D references. 

 CF-formula=
 CF-expression ;
 CF-expression= {space}, CF-nospace-expression, {space} ;
 CF-nospace-expression= 
 "(", CF-expression, ")" | 
 CF-constant | 
 prefix-operator, CF-expression | 
 CF-expression, CF-infix-operator, CF-expression | 
 CF-expression, postfix-operator | 
 A1-reference |
 CF-function-call | 
 name ;
 CF-constant=
 constant – array-constant ; 
 CF-infix-operator=
 ":" | "^" | "*" | "/" | "+" | "-" | "&"| 
 "=" | "<>" | "<" | "<=" | ">" | ">=" ;
 CF-function-call=
 CF-function-name, "(", CF-function-argument-list, ")" ;
 CF-function-name=
 predefined-function-name | 
 name ;
 CF-function-argument-list =
 [CF-expression], { comma, CF-function-argument-list } ;