Skip to main content

XlCondFmtRule.StopIfTrue Property

Gets or sets whether the conditional formatting rules with lower priority can be applied.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v24.1.Core.dll

NuGet Package: DevExpress.Printing.Core

Declaration

public bool StopIfTrue { get; set; }

Property Value

Type Description
Boolean

true, to prevent applying conditional formatting rules with a lower priority; otherwise, false.

Remarks

Use this property to manage overlapping conditional formatting rules in a cell.

For example, there are two conditional formatting rules (1 and 2) applied to the same cell range. The rule 2 was created last, so it has the highest priority. If there is a cell that satisfies the conditions of both rules, both of them will be applied. But when you set the StopIfTrue property of rule 2 to true, only this rule will be applied to the cell that satisfies both conditional formatting criteria.

Note that the StopIfTrue property doesn’t take effect for rules that format cells using data bars, icon sets or color scale.

See Also