Conditional Formatting

In order to highlight important information in rows or columns of a worksheet, DsExcel .NET allows users to create conditional formatting rules for individual cells or a range of cells based on cell values. If the format condition matches with the cell value, it is assumed as true and the cell is formatted as per the specified rule.

For instance, let us assume you want a cell or a range of cells to appear in italics when the value entered in them is lower than 90. To accomplish this, you would apply a conditional formatting rule that will change the format of the cell as soon as the condition is met. Other cells will appear in general format which is the default format of the cells in a spreadsheet.

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.

Pictures in Cell Conditional Formatting Support

In addition to standard cell values, DsExcel .NET also supports conditional formatting for cells that contain pictures (rich data type). The following conditional formatting rule types are supported for pictures in cells:

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

• Cell Value Rule

• Date Occurring Rule

• Average Rule

• Color Scale Rule

• Data Bar Rule

• Top Bottom Rule

• Unique Rule

• Icon Sets Rule

• 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