Partager via


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.