XL2000: Programmatically Changing Conditional Formatting Returns Unexpected Results

When you use Microsoft Visual Basic code to remove the background color property of the conditional formatting of a cell, you receive unexpected results when you try to re-apply the conditional formatting. Although the background color has been successfully removed, it still appears to be selected in the Format Cells dialog box.

Reset the formatting manually, and then select a new background color. To do this, follow these steps:

1. On the Format menu, click Conditional Formatting.
2. In the Conditional Formatting dialog box, click Format.
3. In the Format Cells dialog box, click Clear, and then select a new background color. Click OK twice.

Microsoft has confirmed that this is a problem in Excel 2000.

For more information about how to change conditional formatting, click Microsoft Excel Help on the Help menu, type change conditional formats in the Office Assistant or the Answer Wizard, and then click Search to view the topic.