Export (0) Print
Expand All

3.2.3.1.2 Conditional Formatting Formulas

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 } ;
Show:
© 2015 Microsoft