Microsoft KB Archive/215156

= XL2000: Programmatically Changing Conditional Formatting Returns Unexpected Results =

Article ID: 215156

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



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.

