Spread ASP.NET 17
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / SetConditionalFormat Method / SetConditionalFormat(Int32,Int32,NamedStyle,ComparisonOperator,String,String) 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 parameter values
First specified value
Last specified value
Example


In This Topic
    SetConditionalFormat(Int32,Int32,NamedStyle,ComparisonOperator,String,String) Method
    In This Topic
    Sets conditional formatting based on a specified comparison 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 String, _
       ByVal lastCondition As String _
    ) 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 String
    Dim lastCondition As String
    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 parameter values
    firstCondition
    First specified value
    lastCondition
    Last specified value

    Return Value

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