Spread WPF 14
GrapeCity.Windows.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.

In This Topic
    AddCellValueRule Method
    In This Topic
    Adds the cell value rule to the rule collection.
    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
    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


    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.

    Return Value

    Returns the new cell value rule.
    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.Windows.SpreadSheet.Data.StyleInfo();
    style2.Background = new SolidColorBrush(Colors.Yellow);
    GcSpreadSheet1.Sheets[0].ConditionalFormats.AddCellValueRule(GrapeCity.Windows.SpreadSheet.Data.ComparisonOperator.Between, 1, 8, style2, new GrapeCity.Windows.SpreadSheet.Data.CellRange[] {new GrapeCity.Windows.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.Windows.SpreadSheet.Data.StyleInfo()
    style2.Background = New SolidColorBrush(Colors.Yellow)
    GcSpreadSheet1.Sheets(0).ConditionalFormats.AddCellValueRule(GrapeCity.Windows.SpreadSheet.Data.ComparisonOperator.Between, 1, 8, style2, New GrapeCity.Windows.SpreadSheet.Data.CellRange() {New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 5, 1)})
    See Also