Represents an above average visual of a conditional formatting rule. Applying a color or fill to a range or selection to help you see the value of a cells relative to other cells.
public interface class AboveAverage
[System.Runtime.InteropServices.Guid("0002449E-0000-0000-C000-000000000046")] [System.Runtime.InteropServices.InterfaceType(2)] public interface AboveAverage
Public Interface AboveAverage
All conditional formatting objects are contained within a FormatConditions collection object, which is a child of a Range collection. You can create an above average formatting rule by using either the Add(XlFormatConditionType, Object, Object, Object, Object, Object, Object, Object) or AddAboveAverage() method of the FormatConditionscollection.
|AboveBelow AboveBelow AboveBelow||
Returns or sets one of the constants of the XlAboveBelow enumeration, specifying if the conditional formatting rule looks for cell values above or below the range average or standard deviation.
|Application Application Application||
When used without an object qualifier, this property returns an _Application object that represents the Microsoft Office Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object. Read-only.
|AppliesTo AppliesTo AppliesTo||
Returns a Range object specifying the cell range to which the formatting rule is applied.
|Borders Borders Borders||
Returns a Borders collection that specifies the formatting of cell borders if the conditional formatting rule evaluates to True. Read-only.
|CalcFor CalcFor CalcFor||
Returns or sets one of the constants of the XlCalcFor enumeration, which specifies the scope of data to be evaluated for the conditional format in a PivotTable report.
|Creator Creator Creator||
Returns a constant in the XlCreator enumeration that indicates the application in which this object was created. Read-only.
|Font Font Font||
Returns a Font object that specifies the font formatting if the conditional formatting rule evaluates to True. Read-only.
|Interior Interior Interior||
Returns an Interior object that specifies a cell's interior attributes for a conditional formatting rule that evaluates to True. Read-only.
|NumberFormat NumberFormat NumberFormat||
Returns or sets the number format applied to a cell if the conditional formatting rule evaluates to True. Read/write Object.
|NumStdDev NumStdDev NumStdDev||
Returns or sets the numeric standard deviation for an AboveAverage object. Read/write Integer.
|Parent Parent Parent||
Returns the parent object for the specified object. Read-only.
|Priority Priority Priority||
Returns or sets the priority value of the conditional formatting rule. The priority determines the order of evaluation when multiple conditional formatting rules exist in a worksheet.
|PTCondition PTCondition PTCondition||
Returns a Boolean value indicating if the conditional format is being applied to a PivotTable chart. Read-only.
|ScopeType ScopeType ScopeType||
Returns or sets one of the constants of the XlPivotConditionScope enumeration, which determines the scope of the conditional format when it is applied to a PivotTable chart.
|StopIfTrue StopIfTrue StopIfTrue||
Returns or sets a Boolean value that determines if additional formatting rules on the cell should be evaluated if the current rule evaluates to True.
|Type Type Type||
Returns one of the constants of the XlFormatConditionType enumeration, which specifies the type of conditional format. Read-only.
|Delete() Delete() Delete()||
Deletes the specified conditional formatting rule object.
|ModifyAppliesToRange(Range) ModifyAppliesToRange(Range) ModifyAppliesToRange(Range)||
Sets the cell range to which this formatting rule applies.
|SetFirstPriority() SetFirstPriority() SetFirstPriority()||
Sets the priority value for this conditional formatting rule to "1" so that it will be evaluated before all other rules on the worksheet.
|SetLastPriority() SetLastPriority() SetLastPriority()||
Sets the evaluation order for this conditional formatting rule so it is evaluated after all other rules on the worksheet.