Spread WPF 14
GrapeCity.Windows.SpreadSheet.Data Namespace / ConditionalFormat Class / AddTwoScaleRule Method
The minimum scale type.
The minimum scale value.
The minimum scale color.
The maximum scale type.
The maximum scale value.
The maximum scale color.
The cell ranges where the rule is applied.
Example


In This Topic
    AddTwoScaleRule Method
    In This Topic
    Adds the two color scale rule to the rule collection.
    Syntax
    'Declaration
     
    Public Function AddTwoScaleRule( _
       ByVal minType As ScaleValueType, _
       ByVal minValue As Object, _
       ByVal minColor As Color, _
       ByVal maxType As ScaleValueType, _
       ByVal maxValue As Object, _
       ByVal maxColor As Color, _
       ByVal ParamArray ranges() As CellRange _
    ) As TwoColorScaleRule
    'Usage
     
    Dim instance As ConditionalFormat
    Dim minType As ScaleValueType
    Dim minValue As Object
    Dim minColor As Color
    Dim maxType As ScaleValueType
    Dim maxValue As Object
    Dim maxColor As Color
    Dim ranges() As CellRange
    Dim value As TwoColorScaleRule
     
    value = instance.AddTwoScaleRule(minType, minValue, minColor, maxType, maxValue, maxColor, ranges)
    public TwoColorScaleRule AddTwoScaleRule( 
       ScaleValueType minType,
       object minValue,
       Color minColor,
       ScaleValueType maxType,
       object maxValue,
       Color maxColor,
       params CellRange[] ranges
    )

    Parameters

    minType
    The minimum scale type.
    minValue
    The minimum scale value.
    minColor
    The minimum scale color.
    maxType
    The maximum scale type.
    maxValue
    The maximum scale value.
    maxColor
    The maximum scale color.
    ranges
    The cell ranges where the rule is applied.

    Return Value

    Returns the new two color scale rule.
    Example
    This example creates a two scale rule.
    GcSpreadSheet1.Sheets[0].Cells[0, 0].Value = -1;
    GcSpreadSheet1.Sheets[0].Cells[1, 0].Value = 49;
    GcSpreadSheet1.Sheets[0].Cells[2, 0].Value = 101;
    GcSpreadSheet1.Sheets[0].ConditionalFormats.AddTwoScaleRule(GrapeCity.Windows.SpreadSheet.Data.ScaleValueType.Number, 1, Colors.Yellow,  GrapeCity.Windows.SpreadSheet.Data.ScaleValueType.Number, 100, Colors.Red, new GrapeCity.Windows.SpreadSheet.Data.CellRange[] { new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 20, 1) });
    GcSpreadSheet1.Sheets(0).Cells(0, 0).Value = -1
    GcSpreadSheet1.Sheets(0).Cells(1, 0).Value = 49
    GcSpreadSheet1.Sheets(0).Cells(2, 0).Value = 101
    GcSpreadSheet1.Sheets(0).ConditionalFormats.AddTwoScaleRule(GrapeCity.Windows.SpreadSheet.Data.ScaleValueType.Number, 1, Colors.Yellow, GrapeCity.Windows.SpreadSheet.Data.ScaleValueType.Number, 100, Colors.Red, New GrapeCity.Windows.SpreadSheet.Data.CellRange() { New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 20, 1) })
    See Also