ConditionalFormattingValue Interface

Represents a minimum or maximum threshold for a conditional formatting rule.

Namespace: DevExpress.Spreadsheet

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

Declaration

C#

public interface ConditionalFormattingValue

VB.NET

Public Interface ConditionalFormattingValue

Related API Members

The following members return ConditionalFormattingValue objects:

• ColorScale2ConditionalFormatting.MaxPoint
• ColorScale2ConditionalFormatting.MinPoint
• ColorScale3ConditionalFormatting.MidPoint
• ConditionalFormattingCollection.CreateValue(ConditionalFormattingValueType, String)
• ConditionalFormattingCollection.CreateValue(ConditionalFormattingValueType)
• DataBarConditionalFormatting.HighBound
• DataBarConditionalFormatting.LowBound

Remarks

For details on how to specify the threshold value, see the How to: Format Cells Using a Two-Color Scale, How to: Format Cells Using a Three-Color Scale and How to: Format Cells Using Data Bars examples.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the ConditionalFormattingValue interface.

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.

C#

how-to-apply-conditional-formatting-to-a-range-of-cells-e4929/CS/SpreadsheetControl/SpreadsheetActions/ConditionalFormatting.cs#L262

// 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.

how-to-apply-conditional-formatting-to-a-range-of-cells-wpf-spreadsheet-e4968/CS/ConditionalFormatting_WPF_Examples/SpreadsheetActions/ConditionalFormatting.cs#L261

// 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.

how-to-apply-conditional-formatting-to-a-range-of-cells-e4959/CS/ConditionalFormatting_Example/SpreadsheetActions/ConditionalFormatting.cs#L264

// 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.

VB.NET

how-to-apply-conditional-formatting-to-a-range-of-cells-e4929/VB/SpreadsheetControl/SpreadsheetActions/ConditionalFormatting.vb#L227

' 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.

how-to-apply-conditional-formatting-to-a-range-of-cells-wpf-spreadsheet-e4968/VB/ConditionalFormatting_WPF_Examples/SpreadsheetActions/ConditionalFormatting.vb#L225

' 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.

how-to-apply-conditional-formatting-to-a-range-of-cells-e4959/VB/ConditionalFormatting_Example/SpreadsheetActions/ConditionalFormatting.vb#L226

' 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.