Skip to main content

TopBottomRuleFormatCondition Members

Represents a top/bottom format condition.

Constructors

Name Description
TopBottomRuleFormatCondition() Initializes a new instance of the TopBottomRuleFormatCondition class with default settings.

Fields

Name Description
ApplyToRowProperty static Identifies the ExpressionConditionBase.ApplyToRow bindable property. Inherited from ExpressionConditionBase.
ExpressionProperty static Identifies the ExpressionConditionBase.Expression bindable property. Inherited from ExpressionConditionBase.
FieldNameProperty static Identifies the FormatConditionBase.FieldName bindable property. Inherited from FormatConditionBase.
FormatProperty static Identifies the ExpressionConditionBase.Format bindable property. Inherited from ExpressionConditionBase.
OwnerProperty static Identifies the FormatConditionBase.Owner bindable property. Inherited from FormatConditionBase.
PredefinedFormatNameProperty static Identifies the FormatConditionBase.PredefinedFormatName bindable property. Inherited from FormatConditionBase.
RuleProperty static Identifies the TopBottomRuleFormatCondition.Rule bindable property.
ThresholdProperty static Identifies the TopBottomRuleFormatCondition.Threshold bindable property.

Properties

Name Description
ApplyToRow Specifies whether to apply formatting settings to the entire row. This is a bindable property. Inherited from ExpressionConditionBase.
Expression Gets or sets the expression specifying to which cells the format should be applied. This is a bindable property. Inherited from ExpressionConditionBase.
FieldName Gets or sets the name of the column which provides values to test against the current format rule, and to which the format should be applied. This is a bindable property. Inherited from FormatConditionBase.
Format Gets or sets the formatting settings applied to cells whose values take part in conditional formatting. This is a bindable property. Inherited from ExpressionConditionBase.
Owner Gets the format condition’s owner. This is a bindable property. Inherited from FormatConditionBase.
PredefinedFormatName Gets or sets the name of the predefined format to be applied to target cells. This is a bindable property. Inherited from FormatConditionBase.
Rule Specifies the rule for the top/bottom conditional formatting. This is a bindable property.
Threshold Specifies the number or percentage of cells (or corresponding rows) to format. This is a bindable property.
TypeName Gets or sets the data type name. This property supports the internal infrastructure and is not intended to be used directly from your code. Inherited from FormatConditionBase.
See Also