GrapeCity.Documents.Excel.IColorScaleCriterion.Value

Value Property

Value

Gets or sets the minimum, midpoint, or maximum threshold value for a color scale conditional format.

You can set the value only if the criterion type is set by Type to Number, Percent, Percentile, or Formula. If the threshold type is a formula, the value is specified or returned as a string. The formula must return a single number.

Declaration

object Value { get; set; }

Property Value As Object

Examples

IColorScale colorScale = worksheet.Range["A1:A5"].FormatConditions
    .AddColorScale(ColorScaleType.TwoColorScale);
IColorScaleCriterion criterion = colorScale.ColorScaleCriteria[0];
criterion.Type = ConditionValueTypes.Number;
criterion.Value = 10;
object value = criterion.Value;