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.

Share via

2.5.16 CFTemp

Additional resources