FormatConditionType

Overview

FormatConditionType is a enum in Aspose.Cells for NET.

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