Microsoft KB Archive/270099

= XL2001: Conditional Formatting in Column Settings Is Not Adjusted When List is Copied =

Article ID: 270099

Article Last Modified on 1/27/2007

-

APPLIES TO


 * Microsoft Excel 2001 for Mac

-



This article was previously published under Q270099



SYMPTOMS
When you use copy and paste to create a copy of a list that contains conditional formatting, the conditional formatting in the new list works correctly.

However, when you double-click the header of a column that contains conditional formatting in the new list, and then click Conditional Formatting, the Condition that is set in the Conditional Formatting dialog box references an incorrect location. The Condition may reference a location in the old list that was copied.

NOTE: This problem should not affect the operation of the conditional formatting in your new list. The cells in the new list will reference the correct location, and so the conditional formatting in the new list should work correctly.



WORKAROUND
To work around this problem, follow these steps:
 * 1) Select a cell in the column that contains your conditional formatting.
 * 2) Click Column Settings on the List toolbar, and then click Conditional Formatting.
 * 3) Edit the Condition settings to reflect the correct relative cells, and then click OK.



STATUS
Microsoft has confirmed that this is a problem in Microsoft Excel 2001 for Mac.

Additional query words: off2001kb mac XL2001KB

Keywords: kbbug kbpending KB270099

-

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

© Microsoft Corporation. All rights reserved.