Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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.




Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.