Microsoft KB Archive/272874

= XL2001: Conditional Format in Column Settings Is Not Adjusted =

Article ID: 272874

Article Last Modified on 1/29/2007

-

APPLIES TO


 * Microsoft Excel 2001 for Mac

-



This article was previously published under Q272874



SYMPTOMS
When you apply conditional formatting to a column in a list and the condition contains a relative reference, the reference is set for the first cell in the column. If you insert a row above the first row or delete the first row, the relative reference for each cell is maintained, but the conditional formatting in the Column Settings on the List toolbar still displays the original reference, instead of the reference found in the new first cell in that column.



WORKAROUND
To work around this behavior, do one of the following:
 * Use the Conditional Formatting command on the Format menu to apply conditional formatting to cells in a list. or


 * Change the condition in the Column Settings' Conditional Formatting dialog box to match the condition of the new first cell in the column by typing in the new condition.



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



MORE INFORMATION
For more information about applying conditional formatting, follow these steps:
 * 1) On the Help menu, click Contents and Index, click Index, and then click F.
 * 2) Scroll down until you locate format, and then click the arrow to the left to view a list of topics under the general topic.
 * 3) Click Apply conditional formatting by using the List Manager.

If you cannot find the information that you want, ask the Office Assistant.

