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 CellCaption 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 ApplyTo property specifies whether the ConditionalFormat object is applied to items or to a column