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