ConditionalFormattingValueType Enum

Lists values that specify the type of the threshold value to be used in conditional formatting rules.

Namespace: DevExpress.Spreadsheet

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

Declaration

C#

public enum ConditionalFormattingValueType

VB.NET

Public Enum ConditionalFormattingValueType

Members

Name	Description
Unknown	This value supports the internal infrastructure, and is not intended to be used directly from your code.
Formula	Indicates that a formula is used to specify the threshold value for the conditional formatting rule.
Number	Indicates that a number value is used to specify the threshold value for the conditional formatting rule.
Percent	Indicates that a percent value is used to specify the threshold value for the conditional formatting rule.
Percentile	Indicates that a percentile value is used to specify the threshold value for the conditional formatting rule.
MinMax	Indicates that the lowest (highest) value in the range is used to specify the minimum (maximum) threshold value for the conditional formatting rule.
Auto	For the data bar conditional formatting rule only. Indicates that the minimum (maximum) threshold value is automatically set to zero or the minimum (maximum) value in the range of cells, which ever is smaller (larger).

Related API Members

The following properties accept/return ConditionalFormattingValueType values:

• ConditionalFormattingValue.ValueType

Remarks

The values listed by this enumeration are used by the ConditionalFormattingValue.ValueType property.

Related GitHub Examples

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

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.