XlConditionValueTypes enumeration (Excel)
Specifies the types of condition values that can be used.
| Name | Value | Description |
|---|---|---|
| xlConditionValueAutomaticMax | 7 | The longest data bar is proportional to the maximum value in the range. |
| xlConditionValueAutomaticMin | 6 | The shortest data bar is proportional to the minimum value in the range. |
| xlConditionValueFormula | 4 | Formula is used. |
| xlConditionValueHighestValue | 2 | Highest value from the list of values. |
| xlConditionValueLowestValue | 1 | Lowest value from the list of values. |
| xlConditionValueNone | -1 | No conditional value. |
| xlConditionValueNumber | 0 | Number is used. |
| xlConditionValuePercent | 3 | Percentage is used. |
| xlConditionValuePercentile | 5 | Percentile is used. |
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.