FormatConditions.AddAboveAverage Method
| Excel Developer Reference |
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.
See Also