[ms-xlsx]: Excel (. xlsx) Extensions to the Office Open xml spreadsheetml file Format

gte: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the CT_Cfvo will use greater-than or greater-than-or-equal-to when applying conditional formatting rules. If this CT_Cfvo element is a child of something other than a CT_IconSet element, this attribute MUST NOT be present. The value of this attribute is interpreted as follows:

Value	Meaning
"false"	Greater-than is used when applying conditional formatting rules.
"true"	Greater-than-or-equal-to is used when applying conditional formatting rules.

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.

See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

2.6.27 CT_CfRule

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

Referenced by: CT_ConditionalFormatting

This complex type specifies a conditional formatting rule for a range.

Child Elements:

xm:f: f elements that specify the formulas in the conditional formatting rule. The formulas MUST adhere to the grammar specified in Formulas, with the following restrictions:

 The formula MUST NOT conform to the ref-infix-operator, book-prefix, local-cell-reference, array-constant, bang-reference, bang-name, sheet-range-reference, or structure-reference production rules.

 The formula MUST NOT match the single-sheet-area production rule.

The following table explains how to interpret the formulas.

Value of type