Document Solutions for Excel, Java Edition | Document Solutions
com.grapecity.documents.excel Package / IColorScaleCriterion Interface

In This Topic
    IColorScaleCriterion Interface Methods
    In This Topic

    For a list of all members of this type, see IColorScaleCriterion members.

    Public Methods
     NameDescription
     MethodReturns a FormatColor object, which specifies the color assigned to the threshold of a color scale conditional format.  
     MethodReturns an Integer value that indicates which threshold the criteria represents.  
     MethodReturns 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.  
     MethodReturns the minimum, midpoint, or maximum threshold value for a color scale conditional format.

    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.

     
     MethodSets 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.  
     MethodSets the minimum, midpoint, or maximum threshold value for a color scale conditional format.

    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.

     
    Top
    See Also