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@operator (§3.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>