.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+

ConditionalFormattingCollection.CreateIconSetValue(ConditionalFormattingValueType, String, ConditionalFormattingValueOperator) Method

Specifies the threshold value for the icon set conditional formatting rule.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v21.2.Core.dll


ConditionalFormattingIconSetValue CreateIconSetValue(
    ConditionalFormattingValueType valueType,
    string value,
    ConditionalFormattingValueOperator comparisonOperator


Name Type Description
valueType ConditionalFormattingValueType

One of the ConditionalFormattingValueType enumeration values.

value String

A string that is the threshold value.

comparisonOperator ConditionalFormattingValueOperator

One of the ConditionalFormattingValueOperator enumeration values.


Type Description

A ConditionalFormattingIconSetValue object that defines the threshold value and its ConditionalFormattingValueType type.


If you use a formula to determine the threshold value (the valueType is set to ConditionalFormattingValueType.Formula), start it with an equals sign (=). The formula can include built-in spreadsheet functions. Note that use of relative references is not allowed.

See Also