Edytuj

Udostępnij za pośrednictwem

XlConditionValueTypes Enum

  • Reference

Definition

Namespace:
Microsoft.Office.Interop.Excel
Assembly:
Microsoft.Office.Interop.Excel.dll

Specifies the types of condition values that can be used.

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

Fields

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.

Applies to