XlAutoFilterOperator enumeration

Office 2013 and later

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

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

No code example is currently available or this language may not be supported.

	Member name	Description
	xlAnd	Logical AND of Criteria1 and Criteria2.
	xlBottom10Items	Lowest-valued items displayed (number of items specified in Criteria1).
	xlBottom10Percent	Lowest-valued items displayed (percentage specified in Criteria1).
	xlOr	Logical OR of Criteria1 and Criteria2.
	xlTop10Items	Highest-valued items displayed (number of items specified in Criteria1).
	xlTop10Percent	Lowest-valued items displayed (percentage of items specified in Criteria1).
	xlFilterValues	Filter values
	xlFilterCellColor	Color of the cell
	xlFilterFontColor	Color of the font
	xlFilterIcon	Filter icon
	xlFilterDynamic	Dynamic filter
	xlFilterNoFill	Reserved for internal use.
	xlFilterAutomaticFontColor	Reserved for internal use.
	xlFilterNoIcon	Reserved for internal use.