GrapeCity.Documents.Excel.IColorScale.ColorScaleCriteria

ColorScaleCriteria Property

ColorScaleCriteria

Gets the color scale criteria collection.

Declaration

IColorScaleCriteria ColorScaleCriteria { get; }

ReadOnly Property ColorScaleCriteria As IColorScaleCriteria

Examples

IRange range = worksheet.Range["A1:A5"];
range.Value = new object[,] {{10}, {30}, {50}, {70}, {90}};
IColorScale colorScale = range.FormatConditions.AddColorScale(ColorScaleType.TwoColorScale);
IColorScaleCriteria criteria = colorScale.ColorScaleCriteria;
criteria[0].FormatColor.Color = Color.Red;