Condition Options

The following is a list of the available Condition options that you can use in the Filters tab and the Conditional Formatting tab:

• contains
• does not contain
• equals
• does not equal
• is empty
• is not empty

White spaces (blank characters):

• Filters tab: All leading and trailing white spaces (blank characters) are included in the condition; that is, they are not trimmed.
• Conditional Formatting tab: When you use any of these options on the Conditional Formatting tab, all leading and trailing white spaces are excluded; that is, they are trimmed.

Case sensitivity: When you use equals or does not equal, the results are case sensitive.