ConditionalFormattingIconSetValue Interface

Represents a threshold value for an icon set conditional formatting rule.

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

Declaration

C#
VB.NET

public interface ConditionalFormattingIconSetValue :
    ConditionalFormattingValue

Public Interface ConditionalFormattingIconSetValue
    Inherits ConditionalFormattingValue

Remarks

For details on how to specify the threshold value, see the How to: Format Cells Using Icon Sets example.

The following code snippets (auto-collected from DevExpress Examples) contain references to the ConditionalFormattingIconSetValue 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#
VB.NET

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

// Set the first threshold to the lowest value in the range of cells using the MIN() formula.
ConditionalFormattingIconSetValue minPoint = conditionalFormattings.CreateIconSetValue(ConditionalFormattingValueType.Formula, "=MIN($E$2:$E$15)", ConditionalFormattingValueOperator.GreaterOrEqual);
// Set the second threshold to 0.

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

// Set the first threshold to the lowest value in the range of cells using the MIN() formula.
ConditionalFormattingIconSetValue minPoint = conditionalFormattings.CreateIconSetValue(ConditionalFormattingValueType.Formula, "=MIN($E$2:$E$15)", ConditionalFormattingValueOperator.GreaterOrEqual);
// Set the second threshold to 0.

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

// Set the first threshold to the lowest value in the range of cells using the MIN() formula.
ConditionalFormattingIconSetValue minPoint = conditionalFormattings.CreateIconSetValue(ConditionalFormattingValueType.Formula, "=MIN($E$2:$E$15)", ConditionalFormattingValueOperator.GreaterOrEqual);
// Set the second threshold to 0.

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

' Set the first threshold to the lowest value in the range of cells using the MIN() formula.
Dim minPoint As ConditionalFormattingIconSetValue = conditionalFormattings.CreateIconSetValue(ConditionalFormattingValueType.Formula, "=MIN($E$2:$E$15)", ConditionalFormattingValueOperator.GreaterOrEqual)
' Set the second threshold to 0.

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

' Set the first threshold to the lowest value in the range of cells using the MIN() formula.
Dim minPoint As ConditionalFormattingIconSetValue = conditionalFormattings.CreateIconSetValue(ConditionalFormattingValueType.Formula, "=MIN($E$2:$E$15)", ConditionalFormattingValueOperator.GreaterOrEqual)
' Set the second threshold to 0.

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

' Set the first threshold to the lowest value in the range of cells using the MIN() formula.
    Dim minPoint As ConditionalFormattingIconSetValue = conditionalFormattings.CreateIconSetValue(ConditionalFormattingValueType.Formula, "=MIN($E$2:$E$15)", ConditionalFormattingValueOperator.GreaterOrEqual)
' Set the second threshold to 0.

.NET Subscription

Common Tools

Controls

Tools

Controls and Extensions

Tools

Maintenance Mode

.NET Subscription

Common Tools

Controls

Tools

Controls and Extensions

Tools

Maintenance Mode

ConditionalFormattingIconSetValue Interface

Declaration

Remarks

ConditionalFormattingIconSetValue Interface

Declaration

Related API Members

Remarks

Related GitHub Examples