xlAutoFilterOperator

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

xlAnd	Logical AND of Criteria1 and Criteria2 (1)
xlBottom10Items	Lowest-valued items displayed (number of items specified in Criteria1) (4)
xlBottom10Percent	Lowest-valued items displayed (percentage specified in Criteria1) (6)
xlFilterAutomaticFontColor	(Added in 2007) (13)
xlFilterCellColor	(Added in 2007) Color of the cell (8)
xlFilterDynamic	(Added in 2007) Filter dynamic (11)
xlFilterFontColor	(Added in 2007) Color of the font (9)
xlFilterIcon	(Added in 2007) Filter icon (10)
xlFilterNoFill	(Added in 2007) (12)
xlFilterNoIcon	(Added in 2007) (14)
xlFilterValues	(Added in 2007) Filter values (7)
xlOr	Logical OR of Criteria1 and Criteria2 (2)
xlTop10Items	Highest-valued items displayed (number of items specified in Criteria1) (3)
xlTop10Percent	Highest-values items displayed (percentage specified in Criteria1) (5)

xlAnd

Logical AND of Criteria1 and Criteria2 (1)

xlBottom10Items

Lowest-valued items displayed (number of items specified in Criteria1) (4)

xlBottom10Percent

Lowest-valued items displayed (percentage specified in Criteria1) (6)

xlFilterAutomaticFontColor

(Added in 2007) (13)

xlFilterCellColor

(Added in 2007) Color of the cell (8)

xlFilterDynamic

(Added in 2007) Filter dynamic (11)

xlFilterFontColor

(Added in 2007) Color of the font (9)

xlFilterIcon

(Added in 2007) Filter icon (10)

xlFilterNoFill

(Added in 2007) (12)

xlFilterNoIcon

(Added in 2007) (14)

xlFilterValues

(Added in 2007) Filter values (7)

xlOr

Logical OR of Criteria1 and Criteria2 (2)

xlTop10Items

Highest-valued items displayed (number of items specified in Criteria1) (3)

xlTop10Percent

Highest-values items displayed (percentage specified in Criteria1) (5)