GrapeCity.Documents.Excel.IColorScale.StopIfTrue

StopIfTrue Property

StopIfTrue

Returns 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, later conditional formatting rules are not evaluated for cells where this color scale rule evaluates to true. If it returns false, subsequent rules can continue to be evaluated.

Declaration

bool StopIfTrue { get; }

ReadOnly Property StopIfTrue As Boolean

Examples

IRange range = worksheet.Range["A1:A5"];
range.Value = new object[,] {{10}, {30}, {50}, {70}, {90}};
IColorScale colorScale = range.FormatConditions.AddColorScale(ColorScaleType.TwoColorScale);
bool stopIfTrue = colorScale.StopIfTrue;