Top10.ScopeType (Excel)

Returns or sets one of the constants of the XlPivotConditionScope enumeration, which determines the scope of the conditional format when it is applied to a PivotTable. Possible return values are xlDataFieldScope - Based on the data in the specified fields, xlFieldsScope - Based on the specified fields, xlSelectionScope - Based on the specified selection criteria.

The default value is xlSelectionScope, which sets the scope by using the AppliesTo property.


ActiveCell.FormatConditions(1).ScopeType = xlDataFieldScope