XL97: Conditional Format Reapplied After Inserting Cut Cells

ID: Q171237

The information in this article applies to:

Microsoft Excel 97 for Windows

SYMPTOMS

When you select a range of cells, click Cut on the Edit menu, and then insert the cells in a different location on the worksheet, Microsoft Excel may fail to apply conditional formatting to the correct cells.

CAUSE

This problem may occur when you do the following:

You select a range of cells and click Cut on the Edit menu.
```
    -and-
```
You insert the cut cells immediately below a range of cells to which you applied conditional formatting.

Note that Microsoft Excel 97 applies the conditional formatting to the cells you inserted below the original cell with the conditional formatting.

RESOLUTION

To correct this problem, install Microsoft Excel 97 Service Release 1 (SR-1).

STATUS

Microsoft has confirmed this to be a problem in Microsoft Excel 97 for Windows. This problem was corrected in Microsoft Excel 97 SR-1.

For additional information about SR-1, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q172475
   TITLE     : OFF97: How to Obtain and Install MS Office 97 SR-1

REFERENCES

For more information about conditional formatting, click the Index tab in Microsoft Excel Help, type the following text

  formatting cells, conditional formats

and then double-click the selected text to go to the "Apply conditional formats to cells" topic.

Additional query words: XL97 paste sr1

Keywords          : xlformat 
Version           : WINDOWS:97
Platform          : WINDOWS
Issue type        : kbbug
Solution Type     : kbfix

Last Reviewed: November 5, 1998