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