Edit

Share via

AboveAverage.CalcFor property (Excel)

  • Article

Returns or sets one of the constants of the XlCalcFor enumeration, which specifies the scope of data to be evaluated for the conditional format in a PivotTable report.

Syntax

expression.CalcFor

expression A variable that represents an AboveAverage object.

Remarks

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 AboveAverage.ScopeType property is set to xlFieldsScope.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.