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)

No code example is currently available or this language may not be supported.

Member nameDescription
xlConditionValueNoneNo conditional value.
xlConditionValueNumberNumber is used.
xlConditionValueLowestValueLowest value from the list of values.
xlConditionValueHighestValueHighest value from the list of values.
xlConditionValuePercentPercentage is used.
xlConditionValueFormulaFormula is used.
xlConditionValuePercentilePercentile is used.
xlConditionValueAutomaticMinThe shortest data bar is proportional to the minimum value in the range.
xlConditionValueAutomaticMaxThe longest data bar is proportional to the maximum value in the range.
Show: