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

ConditionalFormattingCollection.CreateValue(ConditionalFormattingValueType, String) Method

Specifies the minimum or maximum threshold value for the conditional formatting rule.

Namespace: DevExpress.Spreadsheet

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


ConditionalFormattingValue CreateValue(
    ConditionalFormattingValueType valueType,
    string value


Name Type Description
valueType ConditionalFormattingValueType

One of the ConditionalFormattingValueType enumeration values.

value String

A string that is the threshold value.


Type Description

The ConditionalFormattingValue 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.

The following code snippets (auto-collected from DevExpress Examples) contain references to the CreateValue(ConditionalFormattingValueType, String) method.


The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

See Also