Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

FormatConditions.AddAboveAverage Method

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

Version Information
 Version Added:  Excel 2007

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.




Community Additions

Show:
© 2014 Microsoft