Top10 Top10 Top10 Interface
Represents a top ten visual of a conditional formatting rule. Applying a color to a range helps you see the value of a cell relative to other cells.
public interface class Top10
[System.Runtime.InteropServices.Guid("0002449D-0000-0000-C000-000000000046")] [System.Runtime.InteropServices.InterfaceType(2)] public interface Top10
Public Interface Top10
All conditional formatting objects are contained within a FormatConditions collection object, which is a child of a Range collection. You can create a top 10 formatting rule by using either the Add(XlFormatConditionType, Object, Object, Object, Object, Object, Object, Object) or AddTop10() method of the FormatConditions collection.
|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 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 how the conditional format in a PivotTable report should be evaluated.
|Creator Creator Creator||
Returns a 32-bit integer 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.
|Parent Parent Parent||
Returns the parent object for the specified object. Read-only.
|Percent Percent Percent||
Returns or sets a Boolean value, specifying if the rank is determined by a percentage value.
|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.
|Rank Rank Rank||
Returns or sets an Integer value, specifying either the number or percentage of the rank value for the conditional format rule.
|ScopeType ScopeType ScopeType||
Returns or sets 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.
|TopBottom TopBottom TopBottom||
Returns or sets one of the constants of the XlTopBottom enumeration, determining if the ranking is evaluated from the top or bottom.
|Type Type Type||
Returns 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.