XL2001: Conditional Format in Column Settings Is Not Adjusted (272874)


The information in this article 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.

REFERENCES

For additional information about conditional formatting in lists, click the article number below to view the article in the Microsoft Knowledge Base:

270099 XL2001: Conditional Formatting in Copied List Is Not Adjusted

Modification Type:MajorLast Reviewed:9/11/2002
Keywords:kbbug KB272874
©2002 Microsoft Corporation. All rights reserved.