Spread ASP.NET 17
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / SetConditionalFormat Method / SetConditionalFormat(Int32,Int32,NamedStyle,ComparisonOperator,Expression,Expression) Method
Row index of the cell
Column index of the cell
Style to be applied to the cell if the condition is satisfied
Comparison operator to apply to the cell value and the specified value
First specified expression
First specified expression
Example


In This Topic
    SetConditionalFormat(Int32,Int32,NamedStyle,ComparisonOperator,Expression,Expression) Method
    In This Topic
    Sets conditional formatting based on a specified expression for a specified cell.
    Syntax
    'Declaration
     
    
    Public Overloads Function SetConditionalFormat( _
       ByVal row As Integer, _
       ByVal column 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 style As NamedStyle
    Dim op As ComparisonOperator
    Dim firstCondition As Expression
    Dim lastCondition As Expression
    Dim value As Boolean
     
    value = instance.SetConditionalFormat(row, column, style, op, firstCondition, lastCondition)

    Parameters

    row
    Row index of the cell
    column
    Column index of the cell
    style
    Style to be applied to the cell if the condition is satisfied
    op
    Comparison operator to apply to the cell value and the specified value
    firstCondition
    First specified expression
    lastCondition
    First specified expression

    Return Value

    Boolean: true if successful; false otherwise
    Exceptions
    ExceptionDescription
    No condition is specified or specified condition is empty
    Example
    This example changes the color of the cell based on the value.
    See Also