Spread ASP.NET 16
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / SetFormulaConditionalFormat Method / SetFormulaConditionalFormat(Int32,Int32,NamedStyle,String) Method
Row index of the cell
Column index of the cell
Style to be applied to the cell if the formula evaluates to true
Formula to evaluate for the condition


In This Topic
    SetFormulaConditionalFormat(Int32,Int32,NamedStyle,String) Method
    In This Topic
    Sets conditional formatting based on a specified formula for a specified cell.
    Syntax
    'Declaration
     
    Public Overloads Function SetFormulaConditionalFormat( _
       ByVal row As Integer, _
       ByVal column As Integer, _
       ByVal style As NamedStyle, _
       ByVal formula As String _
    ) As Boolean
    'Usage
     
    Dim instance As SheetView
    Dim row As Integer
    Dim column As Integer
    Dim style As NamedStyle
    Dim formula As String
    Dim value As Boolean
     
    value = instance.SetFormulaConditionalFormat(row, column, style, formula)
    public bool SetFormulaConditionalFormat( 
       int row,
       int column,
       NamedStyle style,
       string formula
    )

    Parameters

    row
    Row index of the cell
    column
    Column index of the cell
    style
    Style to be applied to the cell if the formula evaluates to true
    formula
    Formula to evaluate for the condition

    Return Value

    Boolean: true if successful; false otherwise
    See Also