2.5.16 CFTemp

Article
10/15/2020

The CFTemp enumeration specifies the type of condition that causes conditional formatting to be displayed in cells as part of a conditional formatting rule.

The value of this enumeration MUST be a value from the following table.

Name	Value	Meaning
CF_TEMPLATE_EXPR	0x00000000	Cells are formatted based on their values.
CF_TEMPLATE_FMLA	0x00000001	Cells are formatted based on the result of a formula (section 2.2.2).
CF_TEMPLATE_GRADIENT	0x00000002	A color scale is used to shade the cells based on their values.
CF_TEMPLATE_DATABAR	0x00000003	A data bar is drawn in each cell.
CF_TEMPLATE_MULTISTATE	0x00000004	An icon is displayed in the cell based on its value.
CF_TEMPLATE_FILTER	0x00000005	Cells are formatted when their values are in the top or bottom of the range of all values in the conditional formatting range.
CF_TEMPLATE_BANDEDTABLE	0x00000006	This value is not used.
CF_TEMPLATE_UNIQUEVALUES	0x00000007	Formatting is applied when a cell's value is unique among all other cells in the conditional formatting range.
CF_TEMPLATE_CONTAINSTEXT	0x00000008	Formatting is applied when the cell's value contains specific text.
CF_TEMPLATE_CONTAINSBLANKS	0x00000009	Formatting is applied when the cell's value is blank.
CF_TEMPLATE_CONTAINSNOBLANKS	0x0000000A	Formatting is applied when the cell's value is not blank.
CF_TEMPLATE_CONTAINSERRORS	0x0000000B	Formatting is applied when the cell contains an error.
CF_TEMPLATE_CONTAINSNOERRORS	0x0000000C	Formatting is applied when the cell does not contain an error.
CF_TEMPLATE_CONTAINSFORMULAS	0x0000000D	This value is not used.
CF_TEMPLATE_CONTAINSNOFORMULAS	0x0000000E	This value is not used.
CF_TEMPLATE_TIMEPERIODTODAY	0x0000000F	Formatting is applied when the cell contains a date and that date is today.
CF_TEMPLATE_TIMEPERIODTOMORROW	0x00000010	Formatting is applied when the cell contains a date and that date is tomorrow.
CF_TEMPLATE_TIMEPERIODYESTERDAY	0x00000011	Formatting is applied when the cell contains a date and that date is yesterday.
CF_TEMPLATE_TIMEPERIODLAST7DAYS	0x00000012	Formatting is applied when the cell contains a date and that date occurred within the last seven days.
CF_TEMPLATE_TIMEPERIODLASTMONTH	0x00000013	Formatting is applied when the cell contains a date and that date occurred last month.
CF_TEMPLATE_TIMEPERIODNEXTMONTH	0x00000014	Formatting is applied when the cell contains a date and that date occurs next month.
CF_TEMPLATE_TIMEPERIODTHISWEEK	0x00000015	Formatting is applied when the cell contains a date and that date occurs this week.
CF_TEMPLATE_TIMEPERIODNEXTWEEK	0x00000016	Formatting is applied when the cell contains a date and that date occurs next week.
CF_TEMPLATE_TIMEPERIODLASTWEEK	0x00000017	Formatting is applied when the cell contains a date and that date occurred last week.
CF_TEMPLATE_TIMEPERIODTHISMONTH	0x00000018	Formatting is applied when the cell contains a date and that date occurs this month.
CF_TEMPLATE_ABOVEAVERAGE	0x00000019	Formatting is applied when the cell's value is above the average value of other cells in the conditional formatting range.
CF_TEMPLATE_BELOWAVERAGE	0x0000001A	Formatting is applied when the cell's value is below the average value of other cells in the conditional formatting range.
CF_TEMPLATE_DUPLICATEVALUES	0x0000001B	Formatting is applied when the cell's value matches the value of other cells in the conditional formatting range.
CF_TEMPLATE_COMPARECOLUMNS	0x0000001C	This value is not used.
CF_TEMPLATE_EQUALABOVEAVERAGE	0x0000001D	Formatting is applied when the cell's value is equal to or greater than the average value of other cells in the conditional formatting range.
CF_TEMPLATE_EQUALBELOWAVERAGE	0x0000001E	Formatting is applied when the cell's value is equal to or less than the average value of other cells in the conditional formatting range.

2.5.16 CFTemp

Additional resources