XlConditionValueTypes enumeration
Office 2013 and later
Specifies the types of condition values that can be used.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
| Member name | Description | |
|---|---|---|
| xlConditionValueNone | No conditional value. | |
| xlConditionValueNumber | Number is used. | |
| xlConditionValueLowestValue | Lowest value from the list of values. | |
| xlConditionValueHighestValue | Highest value from the list of values. | |
| xlConditionValuePercent | Percentage is used. | |
| xlConditionValueFormula | Formula is used. | |
| xlConditionValuePercentile | Percentile is used. | |
| xlConditionValueAutomaticMin | The shortest data bar is proportional to the minimum value in the range. | |
| xlConditionValueAutomaticMax | The longest data bar is proportional to the maximum value in the range. |
Show: