Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

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.


Community Additions

Show: