XL97: Conditional Format Reapplied After Inserting Cut Cells

• 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.

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