XlPivotConditionScope enumeration (Excel)

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

Name Value Description
xlDataFieldScope 2 Based on the data in the specified fields.
xlFieldsScope 1 Based on the specified fields.
xlSelectionScope 0 Based on the specified selection criteria.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.