AboveAverage Members
Include Protected Members
Include Inherited Members
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.
The AboveAverage type exposes the following members.
Properties
Name | Description | |
---|---|---|
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 | 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 | Returns a Range object specifying the cell range to which the formatting rule is applied. | |
Borders | Returns a Borders collection that specifies the formatting of cell borders if the conditional formatting rule evaluates to True. Read-only. | |
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 | Returns a constant in the XlCreator enumeration that indicates the application in which this object was created. Read-only. | |
Font | Returns a Font object that specifies the font formatting if the conditional formatting rule evaluates to True. Read-only. | |
Interior | Returns an Interior object that specifies a cell's interior attributes for a conditional formatting rule that evaluates to True. Read-only. | |
NumberFormat | Returns or sets the number format applied to a cell if the conditional formatting rule evaluates to True. Read/write Object. | |
NumStdDev | Returns or sets the numeric standard deviation for an AboveAverage object. Read/write Integer. | |
Parent | Returns the parent object for the specified object. Read-only. | |
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 | Returns a Boolean value indicating if the conditional format is being applied to a PivotTable chart. Read-only. | |
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 | 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 | Returns one of the constants of the XlFormatConditionType enumeration, which specifies the type of conditional format. Read-only. |
Top
Methods
Name | Description | |
---|---|---|
Delete | Deletes the specified conditional formatting rule object. | |
ModifyAppliesToRange | Sets the cell range to which this formatting rule applies. | |
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 | Sets the evaluation order for this conditional formatting rule so it is evaluated after all other rules on the worksheet. |
Top