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)

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

TwoColorScaleConditionalFormattingRule Class
TwoColorScaleConditionalFormattingRule Members
Overload List