Edit

Share via


XlAutoFilterOperator Enum

Definition

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

public enum class XlAutoFilterOperator
public enum XlAutoFilterOperator
Public Enum XlAutoFilterOperator
Inheritance
XlAutoFilterOperator

Fields

Name Value Description
xlAnd 1

Logical AND of Criteria1 and Criteria2.

xlOr 2

Logical OR of Criteria1 and Criteria2.

xlTop10Items 3

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

xlBottom10Items 4

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

xlTop10Percent 5

Lowest-valued items displayed (percentage of items specified in Criteria1).

xlBottom10Percent 6

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

xlFilterValues 7

Filter values

xlFilterCellColor 8

Color of the cell

xlFilterFontColor 9

Color of the font

xlFilterIcon 10

Filter icon

xlFilterDynamic 11

Dynamic filter

xlFilterNoFill 12

Reserved for internal use.

xlFilterAutomaticFontColor 13

Reserved for internal use.

xlFilterNoIcon 14

Reserved for internal use.

Applies to