ConditionalFormattingCollection.CreateIconSetValue(ConditionalFormattingValueType, String, ConditionalFormattingValueOperator) Method

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

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v19.1.Core.dll

Declaration

C#

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

VB.NET

Function CreateIconSetValue(
    valueType As ConditionalFormattingValueType,
    value As String,
    comparisonOperator As ConditionalFormattingValueOperator
) As ConditionalFormattingIconSetValue

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.