Spread Windows Forms 14.0
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class / SetConditionalFormatting Method / SetConditionalFormatting(CellRange[],Boolean,IConditionalFormattingRule[]) Method
Cell ranges
Indicates that rule(s) can be merged into existing conditional formatting if they affect the same cell range(s).
Rules to apply for the specified range of cells


In This Topic
    SetConditionalFormatting(CellRange[],Boolean,IConditionalFormattingRule[]) Method
    In This Topic
    Sets conditional formatting for a specified ranges of cells on the sheet based on specified rules.
    Syntax
    'Declaration
     
    
    Public Overloads Sub SetConditionalFormatting( _
       ByVal cellRanges() As CellRange, _
       ByVal isCombinable As Boolean, _
       ByVal ParamArray rules() As IConditionalFormattingRule _
    ) 
    'Usage
     
    
    Dim instance As SheetView
    Dim cellRanges() As CellRange
    Dim isCombinable As Boolean
    Dim rules() As IConditionalFormattingRule
     
    instance.SetConditionalFormatting(cellRanges, isCombinable, rules)
    public void SetConditionalFormatting( 
       CellRange[] cellRanges,
       bool isCombinable,
       params IConditionalFormattingRule[] rules
    )

    Parameters

    cellRanges
    Cell ranges
    isCombinable
    Indicates that rule(s) can be merged into existing conditional formatting if they affect the same cell range(s).
    rules
    Rules to apply for the specified range of cells
    See Also