2.1.593 Part 1 Section 18.3.1.10, 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.

e.   The standard states that the formula ("[ISO/IEC-29500-1] §18.3.1.43; formula") child element is optional.

Excel requires the formula child element unless the type attribute is “colorScale”, “dataBar”, or “iconSet”.

Show: