FormatConditions.AddAboveAverage method (Excel)

Returns a new AboveAverage object representing a conditional formatting rule for the specified range.

Syntax

expression.AddAboveAverage

expression A variable that represents a FormatConditions object.

Return value

AboveAverage object

Remarks

The AboveAverage object is used to find values above or below an average or standard deviation in a range of cells. For example, you can find the above average performers in an annual performance review, or you can locate manufactured materials that fall below two standard deviations in a quality rating.

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.