GrapeCity.Documents.Excel.IColorScaleCriteria

IColorScaleCriteria Interface

Represents a collection of IColorScaleCriterion objects that define all criteria for a color scale conditional format.

Each criterion specifies a threshold used by the color scale, such as the minimum, midpoint, or maximum value.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public interface IColorScaleCriteria

Public Interface IColorScaleCriteria

Examples

worksheet.Range["A1:A5"].Value = new object[,] {{10}, {20}, {30}, {40}, {50}};
IColorScale colorScale = worksheet.Range["A1:A5"].FormatConditions
    .AddColorScale(ColorScaleType.ThreeColorScale);
IColorScaleCriteria criteria = colorScale.ColorScaleCriteria;
IColorScaleCriterion criterion = criteria[1];

Properties

Name	Description
Count	Returns an integer value that specifies the number of criteria for a color scale conditional format rule. The returned value corresponds to the number of IColorScaleCriterion objects in this collection.
this[int]	Returns a single IColorScaleCriterion object from the ColorScaleCriteria collection. Each criterion represents one threshold in a color scale conditional format, such as the minimum, midpoint, or maximum value.

Name

Description

Count

Returns an integer value that specifies the number of criteria for a color scale conditional format rule.

The returned value corresponds to the number of IColorScaleCriterion objects in this collection.

this[int]

Returns a single IColorScaleCriterion object from the ColorScaleCriteria collection.

Each criterion represents one threshold in a color scale conditional format, such as the minimum, midpoint, or maximum value.