FormatConditionType
Overview
FormatConditionType is a enum in Aspose.Cells for NET.
Description
FormatConditionType is an enumeration type in the Aspose.Cells FOSS library for .NET. It defines a set of named constants that control behavior or specify options within the API. Enumerations like FormatConditionType help ensure type safety by restricting values to a predefined set.
Values
| Value | Description |
|---|---|
CellValue | Condition based on the cell value relative to a threshold |
Expression | Condition based on a custom formula expression |
ContainsText | Condition triggered when cell text contains a specified substring |
NotContainsText | Condition triggered when cell text does not contain a specified substring |
BeginsWith | Condition triggered when cell text starts with a specified string |
EndsWith | Condition triggered when cell text ends with a specified string |
TimePeriod | Condition based on a relative time period such as last week or this month |
DuplicateValues | Highlights cells whose values appear more than once in the range |
UniqueValues | Highlights cells whose values appear exactly once in the range |
Top10 | Highlights the top N values or top N percent of values in the range |
Bottom10 | Highlights the bottom N values or bottom N percent of values in the range |
AboveAverage | Highlights cells whose values exceed the range average |
BelowAverage | Highlights cells whose values fall below the range average |
ColorScale | Applies a graduated color scale across the value range |
DataBar | Displays a proportional data bar inside each cell |
IconSet | Assigns icon indicators based on value thresholds within the range |