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


In This Topic
    SetConditionalFormat(Int32,Int32,NamedStyle,ComparisonOperator,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 value 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 value As String
    Dim value As Boolean
     
    value = instance.SetConditionalFormat(row, column, style, op, value)
    public bool SetConditionalFormat( 
       int row,
       int column,
       NamedStyle style,
       ComparisonOperator op,
       string value
    )

    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
    value
    String with the specified value

    Return Value

    Boolean: true if successful; false otherwise
    Example
    This example changes the color of the cell if the value is greater than 14.
    See Also