GrapeCity.Documents.Excel.IUniqueValues.StopIfTrue

StopIfTrue Property

StopIfTrue

Gets or sets a Boolean value that determines if additional formatting rules on the cell should be evaluated if the current rule evaluates to true.

If this property is true, subsequent conditional formatting rules are not evaluated for cells where this unique-values or duplicate-values rule evaluates to true. If this property is false, later rules continue to be evaluated.

Declaration

bool StopIfTrue { get; set; }

Property StopIfTrue As Boolean

Examples

worksheet.Range["A1:A5"].Value = new object[,] {
    {1}, {2}, {1}, {3}, {4}
};
IUniqueValues condition = worksheet.Range["A1:A5"].FormatConditions.AddUniqueValues();
condition.Interior.Color = Color.Yellow;
condition.DupeUnique = DupeUnique.Unique;
bool stopIfTrue = condition.StopIfTrue;