XL97: Conditional Formatting Not Saved When Saving as HTML (169022)
The information in this article applies to:
- Microsoft Excel 97 for Windows
This article was previously published under Q169022 SYMPTOMS
If you save your workbook as an HTML document, some of the cell formatting
may not be saved with the workbook.
CAUSE
If you use the Conditional Formatting feature to apply formats to cells,
the formatting is not saved with your workbook when you save it as an HTML
document.
RESOLUTION
Currently, there is no way to save your workbook as an HTML document and
have it preserve the formatting created by the Conditional Formatting
feature.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article.
MORE INFORMATION
The Internet Assistant Wizard is not new to Microsoft Excel, but it has
changed significantly since it was released as a free add-in available on
the Microsoft World Wide Web site in January 1996. The Internet Assistant
Wizard is now an installable component of Microsoft Office and/or Microsoft
Excel, and has been enhanced to take advantage of the new Internet features
of Microsoft Office, Microsoft FrontPage, and Microsoft Internet Explorer.
With the Internet Assistant Wizard, you can leverage existing Microsoft
Excel spreadsheet data to create and distribute documents that can be
viewed online with a Web browser, such as Microsoft Internet Explorer. By
clicking a series of buttons in the wizard, you can convert spreadsheet
data to HTML format, either as a separate Web document or into an existing
Web document.
REFERENCES
For more information about Conditional Number formats, click the Index tab
in Microsoft Excel 97 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.
For more information about the Internet Assistant Wizard, click the Index
tab in Microsoft Excel 97 Help, type the following text
and then double-click the selected text to go to the "Add worksheet data or
a chart to a Web page" topic.
| Modification Type: | Major | Last Reviewed: | 10/22/2000 |
|---|
| Keywords: | kbbug KB169022 |
|---|
|