XlCondFmtRule.StopIfTrue Property

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

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v23.2.Core.dll

NuGet Package: DevExpress.Printing.Core

Declaration

C#

public bool StopIfTrue { get; set; }

VB.NET

Public Property StopIfTrue As Boolean

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.