FormatConditionRuleTopBottom Members
Applies a format if a value is in the range of the highest or lowest column values.Constructors
| Name | Description |
|---|---|
| FormatConditionRuleTopBottom() | Initializes a new instance of a FormatConditionRuleTopBottom class. |
Properties
| Name | Description |
|---|---|
| Appearance | Allows you to explicitly set the appearance settings (background and foreground colors and font settings) for target cells. This property’s settings take priority over the style specified by the FormatConditionRuleAppearanceBase.PredefinedName property. Inherited from FormatConditionRuleAppearanceBase. |
| IsValid | Gets whether the current FormatConditionRuleBase object is properly customized. Inherited from FormatConditionRuleBase. |
| PredefinedName | Gets or sets the name of a predefined or custom style applied to target cells. Inherited from FormatConditionRuleAppearanceBase. |
| Rank | Gets or sets a cutoff value that specifies the count or percentage of column cells with the highest or lowest values. |
| RankType | Gets or sets the type of the FormatConditionRuleTopBottom.Rank value. |
| TopBottom | Gets or sets whether the FormatConditionRuleTopBottom rule targets the highest or lowest column values. |
Methods
| Name | Description |
|---|---|
| Assign(FormatConditionRuleBase) | Copies settings from the specified object to the current object. Inherited from FormatConditionRuleBase. |
| BeginUpdate() | Locks the FormatConditionRuleBase by preventing change notifications from being fired, preventing visual updates until the EndUpdate method is called. Inherited from FormatConditionRuleBase. |
| ConvertToDecimal(Object) static | Converts the specified object to the nullable decimal type. Inherited from FormatConditionRuleBase. |
| CreateInstance() | Creates a new instance of the FormatConditionRuleTopBottom class. |
| EndUpdate() | Unlocks the FormatConditionRuleBase object after a call to the BeginUpdate method and causes an immediate visual update. Inherited from FormatConditionRuleBase. |
| Equals(Object, Object) static | Determines whether the specified object instances are considered equal. Inherited from Object. |
| Equals(Object) | Determines whether the specified object is equal to the current object. Inherited from Object. |
| GetHashCode() | Serves as the default hash function. Inherited from Object. |
| GetType() | Gets the Type of the current instance. Inherited from Object. |
| IsFit(IFormatConditionRuleValueProvider) | Returns whether the current rule evaluates to “true” for input values provided by the specified valueProvider. Inherited from FormatConditionRuleBase. |
| MemberwiseClone() protected | Creates a shallow copy of the current Object. Inherited from Object. |
| ReferenceEquals(Object, Object) static | Determines whether the specified Object instances are the same instance. Inherited from Object. |
| ToString() | Returns the text representation of the current object. Inherited from FormatConditionRuleBase. |
See Also