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

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

xlFilterAutomaticFontColor 13

Reserved for internal use.

xlFilterCellColor 8

Color of the cell

xlFilterDynamic 11

Dynamic filter

xlFilterFontColor 9

Color of the font

xlFilterIcon 10

Filter icon

xlFilterNoFill 12

Reserved for internal use.

xlFilterNoIcon 14

Reserved for internal use.

xlFilterValues 7

Filter values

xlOr 2

Logical OR of Criteria1 and Criteria2.

xlTop10Items 3

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

xlTop10Percent 5

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

Applies to