Skip to main content
Row

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

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.v24.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

#Declaration

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:

#Remarks

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

See Also