Enum eExcelConditionalFormattingRuleType
Enum for Conditional Format Type ST_CfType §18.18.12. With some changes.
Namespace: Experior.Core.Data.OfficeOpenXml.ConditionalFormatting
Assembly: Experior.Core.dll
Syntax
public enum eExcelConditionalFormattingRuleTypeFields
| Name | Description |
|---|---|
| AboveAverage | This conditional formatting rule highlights cells that are above the average for all values in the range. |
| AboveOrEqualAverage | This conditional formatting rule highlights cells that are above or equal the average for all values in the range. |
| AboveStdDev | This conditional formatting rule highlights cells that are above the standard
deviationa for all values in the range.
|
| BeginsWith | This conditional formatting rule highlights cells in the range that begin with the given text. |
| BelowAverage | This conditional formatting rule highlights cells that are below the average for all values in the range. |
| BelowOrEqualAverage | This conditional formatting rule highlights cells that are below or equal the average for all values in the range. |
| BelowStdDev | This conditional formatting rule highlights cells that are below the standard deviationa for all values in the range. |
| Between | This conditional formatting rule highlights cells in the range between the given two formulas. |
| Bottom | This conditional formatting rule highlights cells whose values fall in the bottom N bracket as specified. |
| BottomPercent | This conditional formatting rule highlights cells whose values fall in the bottom N percent as specified. |
| ContainsBlanks | This conditional formatting rule highlights cells that are completely blank. |
| ContainsErrors | This conditional formatting rule highlights cells with formula errors. |
| ContainsText | This conditional formatting rule 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 | This conditional formatting rule highlights duplicated values. |
| EndsWith | This conditional formatting rule highlights cells ending with given text. |
| Equal | This conditional formatting rule highlights cells equals to with given formula. |
| Expression | This conditional formatting 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 | This conditional formatting rule highlights cells greater than the given formula. |
| GreaterThanOrEqual | This conditional formatting rule highlights cells greater than or equal the given formula. |
| Last7Days | This conditional formatting rule highlights cells containing dates in the last 7 days. |
| LastMonth | This conditional formatting rule highlights cells containing dates in the last month. |
| LastWeek | This conditional formatting rule highlights cells containing dates in the last week. |
| LessThan | This conditional formatting rule highlights cells less than the given formula. |
| LessThanOrEqual | This conditional formatting rule highlights cells less than or equal the given formula. |
| NextMonth | This conditional formatting rule highlights cells containing dates in the next month. |
| NextWeek | This conditional formatting rule highlights cells containing dates in the next week. |
| NotBetween | This conditional formatting rule highlights cells outside the range in given two formulas. |
| NotContains | This conditional formatting rule highlights cells that does not contains the given formula. |
| NotContainsBlanks | This conditional formatting rule highlights cells that are not blank. |
| NotContainsErrors | This conditional formatting rule highlights cells without formula errors. |
| NotContainsText | This conditional formatting rule highlights cells that do not contain the given text. |
| NotEqual | This conditional formatting rule highlights cells not equals to with given formula. |
| ThisMonth | This conditional formatting rule highlights cells containing dates in this month. |
| ThisWeek | This conditional formatting rule 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 | This conditional formatting rule highlights cells containing today dates. |
| Tomorrow | This conditional formatting rule highlights cells containing tomorrow dates. |
| Top | This conditional formatting rule highlights cells whose values fall in the top N bracket as specified. |
| TopPercent | This conditional formatting rule highlights cells whose values fall in the top N percent as specified. |
| TwoColorScale | Two Color Scale (Low and High Color Scale) |
| UniqueValues | This conditional formatting rule highlights unique values in the range. |
| Yesterday | This conditional formatting rule highlights cells containing yesterday dates. |