officefileapi-devexpress-dot-spreadsheet-79c13fbb.md
Lists values that specify the type of the threshold value to be used in conditional formatting rules.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
public enum ConditionalFormattingValueType
Public Enum ConditionalFormattingValueType
| 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).
|
The following properties accept/return ConditionalFormattingValueType values:
The values listed by this enumeration are used by the ConditionalFormattingValue.ValueType property.
See Also