XlConditionValueTypes Enumeration
Specifies the types of condition values that can be used.
Version Information
Version Added: Excel 2007
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. |