XlAutoFilterOperator Enumeration
Specifies the operator to use to associate two criteria applied by a filter.
Version Information
Version Added: Excel 2007
| Name | Value | Description |
|---|---|---|
| xlAnd | 1 | Logical AND of Criteria1 and Criteria2. |
| xlBottom10Items | 4 | Lowest-valued items displayed (number of items specified in Criteria1). |
| xlBottom10Percent | 6 | Lowest-valued items displayed (percentage specified in Criteria1). |
| xlFilterCellColor | 8 | Color of the cell |
| xlFilterDynamic | 11 | Dynamic filter |
| xlFilterFontColor | 9 | Color of the font |
| xlFilterIcon | 10 | Filter icon |
| xlFilterValues | 7 | Filter values |
| xlOr | 2 | Logical OR of Criteria1 or Criteria2. |
| xlTop10Items | 3 | Highest-valued items displayed (number of items specified in Criteria1). |
| xlTop10Percent | 5 | Highest-valued items displayed (percentage specified in Criteria1). |