This documentation is archived and is not being maintained.

XlFormatConditionType Enumeration

Specifies whether the conditional format is based on a cell value or an expression.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

public enum XlFormatConditionType

Member nameDescription
xlCellValueThe conditional format is based on a cell value.
xlExpressionThe conditional format is based on an expression.
xlColorScaleColor scale
xlDatabarDatabar
xlTop10Top 10 values
xlIconSetsIcon sets
xlUniqueValuesUnique values
xlTextStringText string
xlBlanksConditionBlanks condition
xlTimePeriodTime period
xlAboveAverageConditionAbove average condition
xlNoBlanksConditionNo blanks condition
xlErrorsConditionErrors condition
xlNoErrorsConditionNo errors condition
Show: