FormatCondition.ScopeType procedure builder

FormatCondition.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 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