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
NuGet Package: DevExpress.Spreadsheet.Core
Declaration
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.