XlConditionValueTypes XlConditionValueTypes XlConditionValueTypes Enum

Definition

Specifies the types of condition values that can be used.

public enum class XlConditionValueTypes
public enum XlConditionValueTypes
Public Enum XlConditionValueTypes
Inheritance
XlConditionValueTypesXlConditionValueTypesXlConditionValueTypes

Fields

xlConditionValueAutomaticMax xlConditionValueAutomaticMax xlConditionValueAutomaticMax 7

The longest data bar is proportional to the maximum value in the range.

xlConditionValueAutomaticMin xlConditionValueAutomaticMin xlConditionValueAutomaticMin 6

The shortest data bar is proportional to the minimum value in the range.

xlConditionValueFormula xlConditionValueFormula xlConditionValueFormula 4

Formula is used.

xlConditionValueHighestValue xlConditionValueHighestValue xlConditionValueHighestValue 2

Highest value from the list of values.

xlConditionValueLowestValue xlConditionValueLowestValue xlConditionValueLowestValue 1

Lowest value from the list of values.

xlConditionValueNone xlConditionValueNone xlConditionValueNone -1

No conditional value.

xlConditionValueNumber xlConditionValueNumber xlConditionValueNumber 0

Number is used.

xlConditionValuePercent xlConditionValuePercent xlConditionValuePercent 3

Percentage is used.

xlConditionValuePercentile xlConditionValuePercentile xlConditionValuePercentile 5

Percentile is used.

Applies to