TwoColorScaleConditionalFormattingRule Constructor(Color,Color)

Initializes a new instance of the TwoColorScaleConditionalFormattingRule class.

Syntax

Visual Basic
C#

'Declaration
 
Public Function New( _
   ByVal minColor As Color, _
   ByVal maxColor As Color _
)

'Usage
 
Dim minColor As Color
Dim maxColor As Color
 
Dim instance As New TwoColorScaleConditionalFormattingRule(minColor, maxColor)

public TwoColorScaleConditionalFormattingRule( 
   Color minColor,
   Color maxColor
)

Parameters

minColor: Color of the minimum value.
maxColor: Color of the maximum value.

Example

This example creates a two color scale rule.

fpSpread1.Sheets[0].Cells[0, 0].Value = 3;
fpSpread1.Sheets[0].Cells[1, 0].Value = 2;
fpSpread1.Sheets[0].Cells[1, 1].Value = 10;
fpSpread1.Sheets[0].Cells[0, 1].Value = 1;
FarPoint.Win.Spread.TwoColorScaleConditionalFormattingRule two = new FarPoint.Win.Spread.TwoColorScaleConditionalFormattingRule(System.Drawing.Color.Red, System.Drawing.Color.Yellow);
fpSpread1.Sheets[0].SetConditionalFormatting(0, 0, 2, 2, two);

VB.NET

FpSpread1.Sheets(0).Cells(0, 0).Value = 3
FpSpread1.Sheets(0).Cells(1, 0).Value = 2
FpSpread1.Sheets(0).Cells(1, 1).Value = 10
FpSpread1.Sheets(0).Cells(0, 1).Value = 1
Dim two As New FarPoint.Win.Spread.TwoColorScaleConditionalFormattingRule(System.Drawing.Color.Red, System.Drawing.Color.Yellow)
FpSpread1.Sheets(0).SetConditionalFormatting(0, 0, 2, 2, two)

Reference

TwoColorScaleConditionalFormattingRule Class
TwoColorScaleConditionalFormattingRule Members
Overload List