Share via


AboveAverage.CalcFor Property (Excel)

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.

Version Information

Version Added: Excel 2007

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.

See Also

Concepts

AboveAverage Object

AboveAverage Object Members