Enum eExcelConditionalFormattingRuleType
Enum for Conditional Format Type ST_CfType §18.18.12. With some changes.
Namespace: OfficeOpenXml.ConditionalFormatting
Assembly: EPPlus.dll
Syntax
public enum eExcelConditionalFormattingRuleTypeFields
| Name | Description |
|---|---|
| AboveAverage | Highlights cells that are above the average for all values in the range. |
| AboveOrEqualAverage | Highlights cells that are above or equal to the average for all values in the range. |
| AboveStdDev | Highlights cells that are above the standard deviation for all values in the range.
|
| BeginsWith | Highlights cells in the range that begin with the given text. |
| BelowAverage | Highlights cells that are below the average for all values in the range. |
| BelowOrEqualAverage | Highlights cells that are below or equal to the average for all values in the range. |
| BelowStdDev | Highlights cells that are below the standard deviation for all values in the range. |
| Between | Highlights cells in the range between the given two formulas. |
| Bottom | Highlights cells whose values fall in the bottom N bracket as specified. |
| BottomPercent | Highlights cells whose values fall in the bottom N percent as specified. |
| ContainsBlanks | Highlights cells that are completely blank. |
| ContainsErrors | Highlights cells with formula errors. |
| ContainsText | Highlights cells in the range that begin with the given text. |
| DataBar | This conditional formatting rule displays a gradated data bar in the range of cells. |
| DuplicateValues | Highlights duplicated values. |
| EndsWith | Highlights cells ending with the given text. |
| Equal | Highlights cells equal to the given formula. |
| Expression | This rule contains a formula to evaluate. When the formula result is true, the cell is highlighted. |
| FiveIconSet | This conditional formatting rule applies a 5 set icons to cells according to their values. |
| FourIconSet | This conditional formatting rule applies a 4 set icons to cells according to their values. |
| GreaterThan | Highlights cells greater than the given formula. |
| GreaterThanOrEqual | Highlights cells greater than or equal the given formula. |
| Last7Days | Highlights cells containing dates in the last 7 days. |
| LastMonth | Highlights cells containing dates in the last month. |
| LastWeek | Highlights cells containing dates in the last week. |
| LessThan | Highlights cells less than the given formula. |
| LessThanOrEqual | Highlights cells less than or equal the given formula. |
| NextMonth | Highlights cells containing dates in the next month. |
| NextWeek | Highlights cells containing dates in the next week. |
| NotBetween | Highlights cells outside the range in given two formulas. |
| NotContains | Highlights cells that does not contains the given formula. |
| NotContainsBlanks | Highlights cells that are not blank. |
| NotContainsErrors | Highlights cells without formula errors. |
| NotContainsText | Highlights cells that do not contain the given text. |
| NotEqual | . |
| ThisMonth | Highlights cells containing dates in this month. |
| ThisWeek | Highlights cells containing dates in this week. |
| ThreeColorScale | Three Color Scale (Low, Middle and High Color Scale) |
| ThreeIconSet | This conditional formatting rule applies a 3 set icons to cells according to their values. |
| Today | Highlights cells containing todays date. |
| Tomorrow | Highlights cells containing tomorrows date. |
| Top | Highlights cells whose values fall in the top N bracket as specified. |
| TopPercent | Highlights cells whose values fall in the top N percent as specified. |
| TwoColorScale | Two Color Scale (Low and High Color Scale) |
| UniqueValues | Highlights unique values in the range. |
| Yesterday | Highlights cells containing yesterdays date. |