Add Cell Value Rule

Spread.Services Documentation
Add Cell Value Rule
Collapse All Expand All

Spread.Services Documentation > Developer's Guide > Apply Conditional Formatting > Add Cell Value Rule

The cell value rule compares values entered in the cells with the condition specified in the conditional formatting rule. In order to add a cell value rule, you can use the Formula1 property and Formula2 property of the IFormatCondition interface. You can also use the Operator property of the IFormatCondition interface to set the operator that will perform the comparison operation, like "Between", "Less Than" etc.

Refer to the following example code to add cell value rule to a range of cells in a worksheet.

C# | Copy Code
--- | ---

    // Assigning value using object
    worksheet.Range["A1:A5"].Value = new object[,]
    {
        {1},{3},{5},{7},{9}
    };
    // Defining format rules.
    IFormatCondition condition = worksheet.Range["A1:A5"].FormatConditions.Add(FormatConditionType.CellValue, FormatConditionOperator.Between, 1, 5) as IFormatCondition;
    condition.NumberFormat = "0.000";

Copyright © GrapeCity, inc. All rights reserved.