Share via

XlPivotConditionScope Enumeration

  • Article

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

Version Information
 Version Added:  Excel 2007

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.