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