Spread ASP.NET 17
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / SetConditionalFormat Method / SetConditionalFormat(Int32,Int32,Int32,Int32,NamedStyle,ComparisonOperator,Expression,Expression) Method
Starting row index
Starting column index
Number of rows
Number of columns
Style to be applied to the cell if the condition is satisfied
Comparison operator to apply to the cell value and the parameter values
First parameter value
Last parameter value


In This Topic
    SetConditionalFormat(Int32,Int32,Int32,Int32,NamedStyle,ComparisonOperator,Expression,Expression) Method
    In This Topic
    Sets a parameterized conditional format for the cell at the specified range.
    Syntax
    'Declaration
     
    
    Public Overloads Function SetConditionalFormat( _
       ByVal row As Integer, _
       ByVal column As Integer, _
       ByVal rowCount As Integer, _
       ByVal columnCount As Integer, _
       ByVal style As NamedStyle, _
       ByVal op As ComparisonOperator, _
       ByVal firstCondition As Expression, _
       ByVal lastCondition As Expression _
    ) As Boolean
    'Usage
     
    
    Dim instance As SheetView
    Dim row As Integer
    Dim column As Integer
    Dim rowCount As Integer
    Dim columnCount As Integer
    Dim style As NamedStyle
    Dim op As ComparisonOperator
    Dim firstCondition As Expression
    Dim lastCondition As Expression
    Dim value As Boolean
     
    value = instance.SetConditionalFormat(row, column, rowCount, columnCount, style, op, firstCondition, lastCondition)

    Parameters

    row
    Starting row index
    column
    Starting column index
    rowCount
    Number of rows
    columnCount
    Number of columns
    style
    Style to be applied to the cell if the condition is satisfied
    op
    Comparison operator to apply to the cell value and the parameter values
    firstCondition
    First parameter value
    lastCondition
    Last parameter value

    Return Value

    Boolean: true if successful; false otherwise
    See Also