Partager via


FormatConditions.AddAboveAverage Method

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

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Function AddAboveAverage As Object
'Usage
Dim instance As FormatConditions
Dim returnValue As Object

returnValue = instance.AddAboveAverage()
Object AddAboveAverage()

Return Value

Type: System.Object
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

Reference

FormatConditions Interface

FormatConditions Members

Microsoft.Office.Interop.Excel Namespace