ConditionalValueType Enum

Namespace:

GemBox.Spreadsheet.ConditionalFormatting

Assembly:

GemBox.Spreadsheet.dll

Represents a ConditionalValue type.

• C#
• VB.NET

public enum ConditionalValueType

Public Enum ConditionalValueType

Fields

Automatic	The shortest data bar is proportional to the minimum value and the longest data bar is proportional to the maximum value from the applied ranges.
Formula	A formula.
Highest	Highest value from the applied ranges.
Lowest	Lowest value from the applied ranges.
None	No conditional value.
Number	A constant number.
Percent	A percentage between the lowest and highest values from the applied ranges.
Percentile	A percentile ranking of the values from the applied ranges.