Partager via


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)

Syntax

'Declaration
Public Enumeration XlFormatConditionType
'Usage
Dim instance As XlFormatConditionType
public enum XlFormatConditionType

Members

Member name Description
xlCellValue The conditional format is based on a cell value.
xlExpression The conditional format is based on an expression.
xlColorScale Color scale
xlDatabar Databar
xlTop10 Top 10 values
xlIconSets Icon sets
xlUniqueValues Unique values
xlTextString Text string
xlBlanksCondition Blanks condition
xlTimePeriod Time period
xlAboveAverageCondition Above average condition
xlNoBlanksCondition No blanks condition
xlErrorsCondition Errors condition
xlNoErrorsCondition No errors condition

See Also

Reference

Microsoft.Office.Interop.Excel Namespace