XL2000: Programmatically Changing Conditional Formatting Returns Unexpected Results (215156)


The information in this article applies to:

  • Microsoft Excel 2000
This article was previously published under Q215156

SYMPTOMS

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.

WORKAROUND

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.

STATUS

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

REFERENCES

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.
Modification Type:MajorLast Reviewed:11/5/2003
Keywords:kbbug kbpending KB215156
©2003 Microsoft Corporation. All rights reserved.