New to Telerik Document ProcessingStart a free 30-day trial

Specifies how a threshold value is calculated or interpreted in range-based conditional formatting rules.

Definition

Namespace:Telerik.Windows.Documents.Spreadsheet.Model.ConditionalFormattings

Assembly:Telerik.Windows.Documents.Spreadsheet.dll

Syntax:

C#
public enum ValueType

Fields

The highest value, automatically determined based on the conditional formatting context.

C#
AutomaticHighestValue = 6

The lowest value, automatically determined based on the conditional formatting context.

C#
AutomaticLowestValue = 7

A value calculated from a formula expression.

C#
Formula = 1

The highest value in the range.

C#
HighestValue = 4

The lowest value in the range.

C#
LowestValue = 5

A fixed numeric value.

C#
Number = 0

A percentage of the range span between minimum and maximum values.

C#
Percent = 2

A value at the specified percentile position within the data distribution.

C#
Percentile = 3