[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

ST_ConditionalFormattingOperator (Conditional Format Operators)

These conditional format operators are used for "Highlight Cells That Contain…" rules. For example, "highlight cells that begin with "M2" and contain "Mountain Gear"".

This simple type's contents are a restriction of the XML Schema string datatype.

The following are possible enumeration values for this type:

Enumeration Value

Description

beginsWith (Begins With)

'Begins with' operator

between (Between)

'Between' operator

containsText (Contains)

'Contains' operator

endsWith (Ends With)

'Ends with' operator

equal (Equal)

'Equal to' operator

greaterThan (Greater Than)

'Greater than' operator

greaterThanOrEqual (Greater Than Or Equal)

'Greater than or equal to' operator

lessThan (Less Than)

'Less than' operator

lessThanOrEqual (Less Than Or Equal)

'Less than or equal to' operator

notBetween (Not Between)

'Not between' operator

notContains (Does Not Contain)

'Does not contain' operator

notEqual (Not Equal)

'Not equal to' operator

 

Referenced By

cfRule@operator3.3.1.9)

The following XML Schema fragment defines the contents of this simple type:

<simpleType name="ST_ConditionalFormattingOperator">

   <restriction base="xsd:string">

   <enumeration value="lessThan"/>

   <enumeration value="lessThanOrEqual"/>

   <enumeration value="equal"/>

   <enumeration value="notEqual"/>

   <enumeration value="greaterThanOrEqual"/>

   <enumeration value="greaterThan"/>

   <enumeration value="between"/>

   <enumeration value="notBetween"/>

   <enumeration value="containsText"/>

   <enumeration value="notContains"/>

   <enumeration value="beginsWith"/>

   <enumeration value="endsWith"/>

   </restriction>

</simpleType>