GrapeCity.Documents.Excel.IFormatConditions.AddColorScale

AddColorScale Method

AddColorScale(ColorScaleType)

Returns a new IColorScale object representing a conditional formatting rule that uses gradations in cell colors to indicate relative differences in the values of cells included in a selected range.

Use colorScaleType to specify the type of color scale rule to add.

Declaration

IColorScale AddColorScale(ColorScaleType colorScaleType)

Function AddColorScale(colorScaleType As ColorScaleType) As IColorScale

Parameters

Type	Name	Description
ColorScaleType	colorScaleType	The color scale type to add.

Returns

Type	Description
IColorScale	A new IColorScale object.

Examples

IRange range = worksheet.Range["A1:A5"];
range.Value = new object[,] {{1}, {2}, {3}, {4}, {5}};
IColorScale colorScale = range.FormatConditions.AddColorScale(ColorScaleType.TwoColorScale);
colorScale.ColorScaleCriteria[0].FormatColor.Color = Color.Red;
colorScale.ColorScaleCriteria[1].FormatColor.Color = Color.Green;