GrapeCity.Documents.Excel.IFormatCondition.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 returns true, lower-priority formatting rules on the same cell are not evaluated after the current rule evaluates to true.

Declaration

bool StopIfTrue { get; set; }

Property StopIfTrue As Boolean

Examples

worksheet.Range["A1:B5"].Value = new object[,] {{1, 2}, {0, 1}, {0, 0}, {0, 3}, {4, 5}};
IFormatCondition condition = (IFormatCondition) worksheet.Range["B1:B5"]
    .FormatConditions.Add(FormatConditionType.Expression, FormatConditionOperator.None, "=A1>0", null);
condition.Interior.Color = Color.Yellow;
condition.StopIfTrue = true;
bool stopIfTrue = condition.StopIfTrue;