FormatConditionRuleTopBottom Properties
Applies a format if a value is in the range of the highest or lowest column values.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. |
See Also