Conditional Formatting

## Conditional Formatting In order to enable you to highlight important information in rows or columns of a worksheet, Document Solutions for Excel 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.. Document Solutions for Excel supports all types of conditional formatting rules: - Cell Value - Average - Color Scale - Data Bar - Icon Sets - Top Bottom - Unique - Expression Apply conditional formatting rules to a range using the **Add** method of **IRange.FormatConditions**. You can also use other specific Add methods: - AddAboveAverage - AddColorScale - AddDatabar - AddIconSetCondition - AddTop10 - AddUniqueValues All of the Add functions return an instance of the **IFormatCondition** interface, or an interface specific to another Add method, such as **IAboveAverage**.