Specifies whether the conditional format is based on a cell value or an expression.
Namespace: Spire.Spreadsheet.FormsAssembly: Spire.Spreadsheet (in Spire.Spreadsheet.dll) Version: 3.7.1.8020
Syntax
| C# | Visual Basic | Visual C++ | F# |
public enum ConditionType
Public Enumeration ConditionType
public enum class ConditionType
type ConditionType
Members
| Member | Value | Description |
|---|---|---|
| CellValue | 0 | |
| Expression | 1 | |
| ColorScale | 2 | |
| DataBar | 3 | |
| IconSet | 4 | |
| Top10 | 5 | |
| UniqueValues | 6 | |
| DuplicateValues | 7 | |
| TextString | 8 | |
| NotTextCondition | 9 | |
| StartWith | 10 | |
| EndsWith | 11 | |
| BlanksCondition | 12 | |
| NoBlanksCondition | 13 | |
| ErrorsCondition | 14 | |
| NoErrorsCondition | 15 | |
| TimePeriod | 16 | |
| AboveAverageCondition | 17 |