XL98: Fill Colors Changed to Black or Not Saved in WK3 File (178963)



The information in this article applies to:

  • Microsoft Excel 98 Macintosh Edition

This article was previously published under Q178963

SYMPTOMS

When you open a Lotus 1-2-3 Release 3 format file in Microsoft Excel 98, the fill color of a range of cells may be changed to black. If you open the file in Lotus 1-2-3, the cells are no longer formatted with a fill color.

CAUSE

The problem occurs when the following conditions are true:

  • In Microsoft Excel 98 Macintosh Edition, you create a worksheet and apply a fill color to a range of cells in the worksheet.

    NOTE: To apply a fill color, follow these steps:

    1. Select the cell range.
    2. Click Cells on the Format menu.
    3. Click the Patterns tab, and then click a color.
    -and-

  • You click Save As on the File menu and save the file in the "WK3,FM3(1-2-3)" format.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

If you apply certain colors to a range of cells, and then save the file in the "WK3,FM3(1-2-3)" file format, the colors may be changed to black. The following colors are changed to black:

Olive Green
Dark Green
Dark Teal
Gray-80%
Gray-50%
Gray-40%
Gray-25%
Rose
Tan
Light Yellow
Light Green
Light Turquoise
Pale Blue
Lavender
White

REFERENCES

For more information about shading cells, click Contents and Index on the Help menu, click the Index button in MS Excel Help, type the following text

shading cells

and then double-click the selected text to go to the "Shade cells with solid colors" topic.

Modification Type:MajorLast Reviewed:9/11/2002
Keywords:kb3rdparty kbbug KB178963