XlAutoFilterOperator Enumeration

Specifies the operator to use to associate two criteria applied by a filter.

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

Show: