Spread WinRT Documentation
GrapeCity.Xaml.SpreadSheet.Data Namespace / ConditionalFormat Class / AddCellValueRule Method
The ComparisonOperator comparison operator.
The first value.
The second value.
The style that is set to the cell when the condition is met.
The cell ranges where the rule is applied.
Example


In This Topic
    AddCellValueRule Method
    In This Topic
    Adds the cell value rule to the rule collection.
    Syntax
    'Declaration
     
    Public Function AddCellValueRule( _
       ByVal comparisonOperator As ComparisonOperator, _
       ByVal value1 As Object, _
       ByVal value2 As Object, _
       ByVal style As StyleInfo, _
       ByVal ParamArray ranges() As CellRange _
    ) As CellValueRule
    'Usage
     
    Dim instance As ConditionalFormat
    Dim comparisonOperator As ComparisonOperator
    Dim value1 As Object
    Dim value2 As Object
    Dim style As StyleInfo
    Dim ranges() As CellRange
    Dim value As CellValueRule
     
    value = instance.AddCellValueRule(comparisonOperator, value1, value2, style, ranges)
    public CellValueRule AddCellValueRule( 
       ComparisonOperator comparisonOperator,
       object value1,
       object value2,
       StyleInfo style,
       params CellRange[] ranges
    )

    Parameters

    comparisonOperator
    The ComparisonOperator comparison operator.
    value1
    The first value.
    value2
    The second value.
    style
    The style that is set to the cell when the condition is met.
    ranges
    The cell ranges where the rule is applied.

    Return Value

    Returns the new cell value rule.
    Example
    This example creates a cell value rule.
    GcSpreadSheet1.Sheets[0].Cells[0, 0].Value = 1;
    GcSpreadSheet1.Sheets[0].Cells[1, 0].Value = 10;
    GcSpreadSheet1.Sheets[0].Cells[2, 0].Value = 6;
    GcSpreadSheet1.Sheets[0].Cells[3, 0].Value = -3;
    var style2 = new GrapeCity.Xaml.SpreadSheet.Data.StyleInfo();
    style2.Background = new SolidColorBrush(Windows.UI.Colors.Yellow);
    
    GcSpreadSheet1.Sheets[0].ConditionalFormats.AddCellValueRule(GrapeCity.Xaml.SpreadSheet.Data.ComparisonOperator.Between, 1, 8, style2, new GrapeCity.Xaml.SpreadSheet.Data.CellRange[] {new GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 5, 1)});
    GcSpreadSheet1.Sheets(0).Cells(0, 0).Value = 1
    GcSpreadSheet1.Sheets(0).Cells(1, 0).Value = 10
    GcSpreadSheet1.Sheets(0).Cells(2, 0).Value = 6
    GcSpreadSheet1.Sheets(0).Cells(3, 0).Value = -3
    Dim style2 As New GrapeCity.Xaml.SpreadSheet.Data.StyleInfo()
    style2.Background = New SolidColorBrush(Windows.UI.Colors.Yellow)
    
    GcSpreadSheet1.Sheets(0).ConditionalFormats.AddCellValueRule(GrapeCity.Xaml.SpreadSheet.Data.ComparisonOperator.Between, 1, 8, style2, New GrapeCity.Xaml.SpreadSheet.Data.CellRange() {New GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 5, 1)})
    See Also