XlPivotConditionScope Enumeration
TOC
Collapse the table of content
Expand the table of content
This documentation is archived and is not being maintained.

XlPivotConditionScope Enumeration

Office 2007
This enumeration specifies the conditional formatting applied for filtering values from the PivotTable object.

Version Information
 Version Added:  Excel 2007

NameValueDescription
xlDataFieldScope2Based on the data in the specified fields.
xlFieldsScope1Based on the specified fields.
xlSelectionScope0Based on the specified selection criteria.


Show:
© 2016 Microsoft