XlAutoFilterOperator Enumeration

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)

public enum XlAutoFilterOperator

Member nameDescription
xlAndLogical AND of Criteria1 and Criteria2.
xlBottom10ItemsLowest-valued items displayed (number of items specified in Criteria1).
xlBottom10PercentLowest-valued items displayed (percentage specified in Criteria1).
xlOrLogical OR of Criteria1 and Criteria2.
xlTop10ItemsHighest-valued items displayed (number of items specified in Criteria1).
xlTop10PercentLowest-valued items displayed (percentage of items specified in Criteria1).
xlFilterValuesFilter values
xlFilterCellColorColor of the cell
xlFilterFontColorColor of the font
xlFilterIconFilter icon
xlFilterDynamicDynamic filter
xlFilterNoFillReserved for internal use.
xlFilterAutomaticFontColorReserved for internal use.
xlFilterNoIconReserved for internal use.
Show: