Skip to main content

FormatCondition Members

Represents a format condition based on a specified rule(s) or expression (equal, less, between, etc.).

Constructors

Name Description
FormatCondition() Initializes a new instance of the FormatCondition 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.
Value1Property static Identifies the FormatCondition.Value1 bindable property.
Value2Property static Identifies the FormatCondition.Value2 bindable property.
ValueRuleProperty static Identifies the FormatCondition.ValueRule 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.
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.
Value1 Gets or sets the first constant that is compared with column values. This is a bindable property.
Value2 Gets or sets the second constant that is compared with column values. This is a bindable property.
ValueRule Specifies the rule for conditional formatting. This is a bindable property.
See Also