GrapeCity.Documents.Excel.IColorScaleCriterion

Interface IColorScaleCriterion

Namespace

GrapeCity.Documents.Excel

Assembly

GcDocs.Excel.dll

Represents the criteria for the minimum, midpoint, or maximum thresholds for a color format conditional format.

public interface IColorScaleCriterion

Properties

FormatColor

Returns a FormatColor object, which specifies the color assigned to the threshold of a color scale conditional format (read-only).

IFormatColor FormatColor { get; }

Property Value

IFormatColor

Index

Returns an Integer value that indicates which threshold the criteria represents (read-only).

int Index { get; }

Property Value

int

Type

Returns one of the constants of the ConditionValueTypes enumeration, which specifies how the threshold values for a data bar or color scale conditional format are determined (read-only).

ConditionValueTypes Type { get; set; }

Property Value

ConditionValueTypes

Value

Returns or sets the minimum, midpoint, or maximum threshold value for a color scale conditional format (read or write).

object Value { get; set; }

Property Value

object

Remarks

You can set the value only if the ColorScaleCriterion.Type property for the conditional format is set to one of the following constants: ConditionValueNumber, ConditionValuePercent, ConditionValuePercentile, or ConditionValueFormula. If the type of threshold is a formula, you can set the formula as a String. The formula must return a single number.