Expression1, Expression2 Properties (FormatCondition Object)

See Also                  Applies To

You can use the Expression1 and Expression2 properties to return the values of a conditional format within a FormatCondition object.

Setting

• The Expression1 property returns a Variant value or expression associated with the first part of the conditional format.
  
  
• The Expression2 property returns a Variant value or expression associated with the second part of the conditional format when the Operator property of the FormatCondition object is acBetween or acNotBetween, otherwise, the Expression2 property is NULL.

The Expression1 and Expression2 properties are available only by using Visual Basicand are read-only.

Conditional formatting can also be set on a combo box or text box from the Conditional Formatting dialog box. The Conditional Formatting dialog box is available by clicking Conditional Formatting on the Format menu when a form is in Design view.