This documentation is archived and is not being maintained.

XlPivotConditionScope Enumeration

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

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.

Show: