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

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

Declaration

ConditionalFormattingIconSetValue CreateIconSetValue(
    ConditionalFormattingValueType valueType,
    string value,
    ConditionalFormattingValueOperator comparisonOperator
)

Parameters

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.

Returns

Type Description
ConditionalFormattingIconSetValue

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

Remarks

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