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.
Last Published Wednesday, July 2, 2025