Microsoft KB Archive/268412

= XL2001: Undo of Cut and Paste of Cells with Conditional Formats Doesn't Undo Adjustments to Cell References =

Article ID: 268412

Article Last Modified on 1/27/2007

-

APPLIES TO


 * Microsoft Excel 2001 for Mac

-



This article was previously published under Q268412



SYMPTOMS
When conditional formatting is applied to a cell in Microsoft Excel, and the cell is cut and pasted to another location, undoing the paste may not correctly update the conditional formatting information.



CAUSE
This behavior can occur if both of the following conditions are true:
 * 1) The conditional formatting in the cell is based on the value of another cell.

-and-
 * 1) The destination of the paste operation is the cell on which the conditional formatting is based.

When the cut cell is pasted into the cell on which its conditional formatting is based, the conditional formatting changes. This change is not reversed when the paste operation is undone.



WORKAROUND
To work around this problem, verify the conditional formatting criteria after undoing a paste, and restore cell references as necessary.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: off2001kb mac XL2001KB XL2001 excel undo format reverse backup

Keywords: kbbug kbpending KB268412

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.