officefileapi-devexpress-dot-spreadsheet-dot-conditionalformattingcollection-dot-createvalue-x28-devexpress-dot-spreadsheet-dot-conditionalformattingvaluetype-x29.md
Specifies the minimum or maximum threshold value for the conditional formatting rule.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
ConditionalFormattingValue CreateValue(
ConditionalFormattingValueType valueType
)
Function CreateValue(
valueType As ConditionalFormattingValueType
) As ConditionalFormattingValue
| Name | Type | Description |
|---|---|---|
| valueType | ConditionalFormattingValueType |
One of the ConditionalFormattingValueType enumeration values.
|
| Type | Description |
|---|---|
| ConditionalFormattingValue |
The ConditionalFormattingValue object that defines the threshold value and its ConditionalFormattingValueType type.
|
Use the CreateValue method with the ConditionalFormattingValueType.MinMax parameter to automatically set the maximum/minimum threshold to the highest/lowest value in a range of cells.
The following code snippets (auto-collected from DevExpress Examples) contain references to the CreateValue(ConditionalFormattingValueType) method.
Note
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.
// Set the minimum threshold to the lowest value in the range of cells.
ConditionalFormattingValue minPoint = conditionalFormattings.CreateValue(ConditionalFormattingValueType.MinMax);
// Set the maximum threshold to the highest value in the range of cells.
// Set the minimum threshold to the lowest value in the range of cells.
ConditionalFormattingValue minPoint = conditionalFormattings.CreateValue(ConditionalFormattingValueType.MinMax);
// Set the maximum threshold to the highest value in the range of cells.
// Set the minimum threshold to the lowest value in the range of cells.
ConditionalFormattingValue minPoint = conditionalFormattings.CreateValue(ConditionalFormattingValueType.MinMax);
// Set the maximum threshold to the highest value in the range of cells.
' Set the minimum threshold to the lowest value in the range of cells.
Dim minPoint As ConditionalFormattingValue = conditionalFormattings.CreateValue(ConditionalFormattingValueType.MinMax)
' Set the maximum threshold to the highest value in the range of cells.
' Set the minimum threshold to the lowest value in the range of cells.
Dim minPoint As ConditionalFormattingValue = conditionalFormattings.CreateValue(ConditionalFormattingValueType.MinMax)
' Set the maximum threshold to the highest value in the range of cells.
' Set the minimum threshold to the lowest value in the range of cells.
Dim minPoint As ConditionalFormattingValue = conditionalFormattings.CreateValue(ConditionalFormattingValueType.MinMax)
' Set the maximum threshold to the highest value in the range of cells.
See Also
How to: Format Cells Using a Two-Color Scale
ConditionalFormattingCollection Interface