Creates a new two color scale with the specified parameters.
'Declaration
Public Shared Function Create( _
ByVal As ScaleValueType, _
ByVal As System.Object, _
ByVal As System.Windows.Media.Color, _
ByVal As ScaleValueType, _
ByVal As System.Object, _
ByVal As System.Windows.Media.Color _
) As TwoColorScaleRule
'Usage
Dim minType As ScaleValueType
Dim minValue As System.Object
Dim minColor As System.Windows.Media.Color
Dim maxType As ScaleValueType
Dim maxValue As System.Object
Dim maxColor As System.Windows.Media.Color
Dim value As TwoColorScaleRule
value = TwoColorScaleRule.Create(minType, minValue, minColor, maxType, maxValue, maxColor)
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.
Return Value
The new two color scale rule.
This example uses the two color scale rule.
var rule = GrapeCity.Windows.SpreadSheet.Data.TwoColorScaleRule.Create(GrapeCity.Windows.SpreadSheet.Data.ScaleValueType.Number, 1, Colors.Yellow, GrapeCity.Windows.SpreadSheet.Data.ScaleValueType.Number, 50, Colors.Blue);
rule.Ranges = new GrapeCity.Windows.SpreadSheet.Data.CellRange[] { new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 20, 1) };
gcSpreadSheet1.Sheets[0].ConditionalFormats.AddRule(rule);
Dim rule = GrapeCity.Windows.SpreadSheet.Data.TwoColorScaleRule.Create(GrapeCity.Windows.SpreadSheet.Data.ScaleValueType.Number, 1, Colors.Yellow,
GrapeCity.Windows.SpreadSheet.Data.ScaleValueType.Number, 50, Colors.Blue)
rule.Ranges = New GrapeCity.Windows.SpreadSheet.Data.CellRange() {New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 20, 1)}
GcSpreadSheet1.Sheets(0).ConditionalFormats.AddRule(rule)
Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional (SP4), Windows XP (SP2), Windows 2008, Windows 2003 Server (SP1)