FormatCondition

Overview

FormatCondition is a class in Aspose.Cells for NET.

FormatCondition.Remove removes this conditional format from its worksheet.

Properties

Name	Type	Access	Description
`Type`	`FormatConditionType`	Read/Write	Gets or sets the condition’s format type (e.g., cell value, expression)
`Operator`	`OperatorType`	Read/Write	Gets or sets the comparison operator used in the condition
`Formula1`	`string`	Read/Write	Gets or sets the first formula string for the condition
`Formula2`	`string`	Read/Write	Gets or sets the second formula string for the condition
`Formula`	`string`	Read/Write	Gets or sets a single formula for expression‑type conditions
`TimePeriod`	`string`	Read/Write	Gets or sets the time period identifier for time-based rules
`Duplicate`	`bool`	Read/Write	Gets or sets whether the rule checks for duplicate values
`Top`	`bool`	Read/Write	Gets or sets whether the rule selects the top values
`Percent`	`bool`	Read/Write	Indicates whether the rule uses a percentage threshold
`Rank`	`int`	Read/Write	Gets or sets the numeric rank used with top/bottom rules
`Above`	`bool`	Read/Write	Gets or sets whether the rule applies to values above average
`StandardDeviation`	`int`	Read/Write	Gets or sets the number of standard deviations for the rule
`ColorScaleCount`	`int`	Read/Write	Gets or sets how many colors are used in a color scale
`MinColor`	`Color`	Read/Write	Gets or sets the minimum color in a color‑scale rule
`MidColor`	`Color`	Read/Write	Gets or sets the middle color in a three‑color scale rule
`MaxColor`	`Color`	Read/Write	Gets or sets the maximum color in a color scale
`BarColor`	`Color`	Read/Write	Gets or sets the fill color of data bars in a bar rule
`NegativeBarColor`	`Color`	Read/Write	Gets or sets the fill color for negative data bar values
`ShowBorder`	`bool`	Read/Write	Gets or sets whether data bars display a border
`Direction`	`string`	Read/Write	Gets or sets the direction of data bars (e.g., left‑to‑right)
`BarLength`	`string`	Read/Write	Gets or sets the length type of data bars (e.g., “Automatic”)
`IconSetType`	`string`	Read/Write	Gets or sets the icon set used for icon‑based rules
`ReverseIcons`	`bool`	Read/Write	Gets or sets whether icons are displayed in reverse order
`ShowIconOnly`	`bool`	Read/Write	Indicates whether only the icon is displayed without cell formatting
`Priority`	`int`	Read/Write	Gets or sets the rule’s evaluation order relative to other rules
`StopIfTrue`	`bool`	Read/Write	Indicates whether evaluation stops when this rule evaluates to true
`Style`	`Style`	Read/Write	Gets or sets the style applied when the condition evaluates to true

Methods

Signature	Description
`Remove()`	Deletes this conditional formatting rule from its worksheet