API usageSpreadsheet APIEnumerationXlPivotConditionScopeOn this pageXlPivotConditionScope The scope for pivot table conditional formatting rules. Type Enumeration Values "xlFieldsScope" "xlSelectionScope" "xlDataFieldScope"