Edit

Share via

ColorScale.Formula property (Excel)

  • Article

Returns or sets a String representing a formula that determines the values to which the icon set will be applied.

Syntax

expression.Formula

expression A variable that represents a ColorScale object.

Remarks

This property is useful to limit the range of values that will display the conditional format. A typical scenario is when you have a range of numbers containing both positive and negative values. You may want to create more than one conditional format for this range of numbers—one for positive values and another for negative values.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.