- Click in the cell below Expression.
Two buttons appear on the right. The arrow button displays a list of fields you can use in Expression. The ellipsis (...) button launches Expression Builder, which you can use to create a more complex expression.
- For Expression, specify the filter expression.
- For Operator, select an operator from the drop-down list.
- For Value 1, specify the value to search. You can type the value, select from the list of values, or use Expression Builder to create a more complex value expression.
If you select the Is True, Is False, Is Null, or Is Not Null operator, you do not specify a value.
- For Value 2, specify a value only if you select the Between or Not Between operator.