Top10.CalcFor (Excel)

Returns or sets one of the constants of the XlCalcFor enumeration, which specifies how the conditional format in a PivotTable report should be evaluated. Possible return values are xlAllValues - All values, xlColGroups - Column groups, xlRowGroups - Row groups.

This property is applicable only when the conditional format is being applied to data in a PivotTable report. This property can be set to xlAllValues, xlColGroups, or xlRowGroups only if the ScopeType property is set to xlFieldsScope.


ActiveCell.FormatConditions(1).CalcFor = xlAllValues