2.1.628 Part 4 Section 3.3.1.9, cfRule (Conditional Formatting Rule)

a.   The standard implies that the type attribute is optional.

Excel requires this attribute.

b.   The standard specifies the operator attribute as optional.

Office requires the operator attribute to be specified if and only if type attribute value equals cells.

c.   The standard specifies timePeriod attribute as optional.

Office requires timePeriod attribute to be specified if and only if type attribute value equals timePeriod.

d.   The standard does not specify a default value for the rank attribute.

Excel uses a default value of 0 for this attribute.

Show: