The conditional formatting feature allows you to apply formats to a cell or range of cells, and have that formatting change depending on the value of the cell or the value of a formula. Use the Add method to format cells or items based on a formula. Use the Refresh method to refresh the control, if a change occurs in the conditional format collection. Use the CellValue property indicates the cell's caption or value.

The conditional format feature may change the cells and items as follows:

• Bold property. Bolds the cell or items
• Italic property. Indicates whether the cells or items should appear in italic.
• StrikeOut property. Indicates whether the cells or items should appear in strikeout.
• Underline property. Underlines the cells or items
• Font property. Changes the font for cells or items.
• BackColor property. Changes the background color for cells or items, supports skins as well.
• ForeColor property. Changes the foreground color for cells or items.

The conditional format feature may change the bars as follows:

• The BarColor property specifies the color to be applied to bars if the conditional expression is accomplished. 
• The BarOverviewColor property specifies the color to be applied to bars, in the overview portion of the control, if the conditional expression is accomplished.

The ApplyTo property specifies whether the ConditionalFormat object is applied to items or to a column. The ApplyToBars property specifies the list of bars that the current format is applied to.

The following screen shot shows different colors applied to different items, using the ConditionalFormat feature: