<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>