ConditionalFormatting Constructor(IEnumerable<CellRange>)

Initializes a new instance of the ConditionalFormatting class.

Syntax

Visual Basic
C#

'Declaration
 
Public Function New( _
   ByVal ranges As IEnumerable(Of CellRange) _
)

'Usage
 
Dim ranges As IEnumerable(Of CellRange)
 
Dim instance As New ConditionalFormatting(ranges)

public ConditionalFormatting( 
   IEnumerable<CellRange> ranges
)

Parameters

ranges: The ranges.

Example

This example creates a conditional rule.

private void Form1_Load(object sender, EventArgs e)
        {
            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, 2].Value = 1;            
        }

        private void button1_Click(object sender, EventArgs e)
        {
            FarPoint.Win.Spread.UnaryComparisonConditionalFormattingRule unary = new FarPoint.Win.Spread.UnaryComparisonConditionalFormattingRule(FarPoint.Win.Spread.UnaryComparisonOperator.EqualTo,  10, false);
            unary.Operator = FarPoint.Win.Spread.UnaryComparisonOperator.EqualTo;
            unary.Value = 10;
            unary.BackColor = Color.Red;
            unary.FontStyle = new FarPoint.Win.Spread.SpreadFontStyle(RegularBoldItalicFontStyle.Bold);
            
            FarPoint.Win.Spread.TopRankedValuesConditionalFormattingRule topRank = new FarPoint.Win.Spread.TopRankedValuesConditionalFormattingRule();
            topRank.IsDescending = true;
            topRank.BackColor = Color.Tomato;
            topRank.ForeColor = Color.Yellow;

            //CondtionalFormatting Constructor
            FarPoint.Win.Spread.ConditionalFormatting cf2 = new FarPoint.Win.Spread.ConditionalFormatting(new FarPoint.Win.Spread.Model.CellRange[] { new FarPoint.Win.Spread.Model.CellRange(0, 0, 1, 1), new FarPoint.Win.Spread.Model.CellRange(1, 1, 2, 2) });
            FarPoint.Win.Spread.ConditionalFormatting cf3 = new FarPoint.Win.Spread.ConditionalFormatting(new FarPoint.Win.Spread.Model.CellRange[] { new FarPoint.Win.Spread.Model.CellRange(0, 0, 1, 1), new FarPoint.Win.Spread.Model.CellRange(1, 1, 2, 2) }, topRank);
            fpSpread1.ActiveSheet.Models.ConditionalFormatting.Add(cf2);
            fpSpread1.ActiveSheet.Models.ConditionalFormatting.Add(cf3);
    }

VB.NET

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        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, 2).Value = 1
    End Sub

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim unary As New FarPoint.Win.Spread.UnaryComparisonConditionalFormattingRule(FarPoint.Win.Spread.UnaryComparisonOperator.EqualTo, 10, False)
        unary.Operator = FarPoint.Win.Spread.UnaryComparisonOperator.EqualTo
        unary.Value = 10
        unary.BackColor = Color.Red
        unary.FontStyle = New FarPoint.Win.Spread.SpreadFontStyle(RegularBoldItalicFontStyle.Bold)

        Dim topRank As New FarPoint.Win.Spread.TopRankedValuesConditionalFormattingRule()
        topRank.IsDescending = True
        topRank.BackColor = Color.Tomato
        topRank.ForeColor = Color.Yellow

        'CondtionalFormatting Constructor
        Dim cf2 As New FarPoint.Win.Spread.ConditionalFormatting(New FarPoint.Win.Spread.Model.CellRange() {New FarPoint.Win.Spread.Model.CellRange(0, 0, 1, 1), New FarPoint.Win.Spread.Model.CellRange(1, 1, 2, 2)})
        Dim cf3 As New FarPoint.Win.Spread.ConditionalFormatting(New FarPoint.Win.Spread.Model.CellRange() {New FarPoint.Win.Spread.Model.CellRange(0, 0, 1, 1), New FarPoint.Win.Spread.Model.CellRange(1, 1, 2, 2)}, topRank)
        FpSpread1.ActiveSheet.Models.ConditionalFormatting.Add(cf2)
        FpSpread1.ActiveSheet.Models.ConditionalFormatting.Add(cf3)
    End Sub

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

ConditionalFormatting Class
ConditionalFormatting Members
Overload List