XlAutoFilterOperator Enum
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Specifies the operator to use to associate two criteria applied by a filter.
public enum class XlAutoFilterOperatorpublic enum XlAutoFilterOperatorPublic 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. |