Microsoft KB Archive/107076

= Microsoft Knowledge Base =

Excel: No White Text on Black with Black And White Option
Last reviewed: December 19, 1996

Article ID: Q107076

The information in this article applies to:


 * Microsoft Excel for Windows, versions 4.0, 4.0a, 5.0
 * Microsoft Excel for the Macintosh, versions 4.0, 5.0
 * Microsoft Excel for Windows 95, version 7.0
 * Microsoft Excel 97 for Windows

SUMMARY
In Microsoft Excel, if you have the Black And White (Black & White Cells in versions 4.0, 4.0a) option selected in the Page Setup dialog box, cells formatted with white text on a black background will not print as formatted. Instead, they are printed and appear in print preview as black text on a white background. However, text boxes with the same formatting, will print with white text on a black background even with the Black and White option turned on (except in Microsoft Excel 97).

Steps to Reproduce Problem
  Enter the following data in a new worksheet: A1: one A2: two and select these cells.   Format the selected cells with white text on a black background and select the Black And White print option with the following steps: Versions 5.0, 7.0 and 97 a. On the Format menu, click Cells. b. In the Format Cells dialog box click the Patterns tab. Select black from the Colors box under Cell Shading. c. Click the Font tab, select white from the Color drop-down list and click OK. d. On the File menu, click Page Setup. e. Click the Sheet tab and under Print, click the Black And White check box. Click OK. f. On the File menu click Print Preview. Versions 4.0, 4.0a --    a. From the Format menu, choose Patterns, and select black from the Foreground list. Choose OK. b. From the Format menu, choose Font, and select white from the Color list. Choose OK. c. From the File menu, choose Page Setup. d. Select the Black & White Cells check box and choose OK.  From the File menu, choose Print Preview.

The cells formatted as white text on black background will be displayed as black text on a white background. They will also print out this way.

NOTE: Text boxes formatted with white text on a black background will print as formatted, even with the Black and White print option selected in the Page Setup dialog box (except in Microsoft Excel 97).