Skip to main content
A newer version of this page is available. .

FormatConditionRuleAboveBelowAverage Properties

Applies a format if a cell value is above or below the column’s average.
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.
AverageType Gets or sets the target range relative to a column’s average value.
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.
See Also