XlFormatConditionType enumeration (Microsoft.Office.Interop.Excel)

XlFormatConditionType enumeration

Office 2013 and later

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

No code example is currently available or this language may not be supported.

	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