Apply Conditional Formatting

Spread.Services Documentation
Apply Conditional Formatting
Collapse All Expand All

Spread.Services Documentation > Developer's Guide > Apply Conditional Formatting

You can apply conditional formatting in individual cells or a range of cells using rules or conditional operators. The set of conditional formatting rules for a range is represented with the FormatConditions property of the IRange interface.

Shared below is a list of conditional formatting rules that can be applied in a worksheet.

- Add Cell Value Rule
- Add Date Occurring Rule
- Add Average Rule
- Add Color Scale Rule
- Add Data Bar Rule
- Add Top Bottom Rule
- Add Unique Rule
- Add Icon Sets Rule
- Add Expression Rule

If you want to delete the formatting rule applied to the cell range in a worksheet, you can do it by using the Delete method of IFormatCondition interface

Copyright © GrapeCity, inc. All rights reserved.