Export (0) Print
Expand All
Expand Minimize

XlFormatConditionType Enumeration

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

Version Information
 Version Added:  Excel 2007

NameValueDescription
xlAboveAverageCondition12Above average condition
xlBlanksCondition10Blanks condition
xlCellValue1Cell value
xlColorScale3Color scale
xlDatabar4Databar
xlErrorsCondition16Errors condition
xlExpression2Expression
XlIconSet6Icon set
xlNoBlanksCondition13No blanks condition
xlNoErrorsCondition17No errors condition
xlTextString9Text string
xlTimePeriod11Time period
xlTop105Top 10 values
xlUniqueValues8Unique values


Community Additions

ADD
Show:
© 2014 Microsoft