XlFormatConditionType Enum
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Specifies whether the conditional format is based on a cell value or an expression.
public enum class XlFormatConditionTypepublic enum XlFormatConditionTypePublic Enum XlFormatConditionType- Inheritance
-
XlFormatConditionType
Fields
| Name | Value | Description |
|---|---|---|
| xlCellValue | 1 | The conditional format is based on a cell value. |
| xlExpression | 2 | The conditional format is based on an expression. |
| xlColorScale | 3 | Color scale |
| xlDatabar | 4 | Databar |
| xlTop10 | 5 | Top 10 values |
| xlIconSets | 6 | Icon sets |
| xlUniqueValues | 8 | Unique values |
| xlTextString | 9 | Text string |
| xlBlanksCondition | 10 | Blanks condition |
| xlTimePeriod | 11 | Time period |
| xlAboveAverageCondition | 12 | Above average condition |
| xlNoBlanksCondition | 13 | No blanks condition |
| xlErrorsCondition | 16 | Errors condition |
| xlNoErrorsCondition | 17 | No errors condition |