My negative numbers are not printing in red or at all in excel spread sheet

Question

My negative numbers are supposed to print in red but nothing prints in the excel spread sheet

Answer 1

Hello.

You should first verify that your printer properties aren't overriding Excel's formatting by checking the device's driver dialog to ensure that "Grayscale" or "Black and White" isn't enabled.

Inside Excel, go to the Page Layout tab, open the Page Setup dialog box, and under the Sheet tab, make sure the "Black and white" and "Draft quality" checkboxes are both cleared. If your cells are formatted using a specific Currency or Number format that highlights negatives in red, Windows may fail to send that specific color data to the spooler if the printer driver is set to a restricted color mode.

It is also possible that a Conditional Formatting rule is conflicting with the print output, so checking the Rules Manager under the Home tab to ensure no "No Color" or "White Text" overrides exist is a necessary step. If the entire spreadsheet is coming out blank rather than just the red numbers, the issue likely resides in the Print Area definition which you can reset by clearing all print areas from the Page Layout menu. Please let me know if the rest of the text appears normally or if the entire page is blank, as this distinguishes between a color rendering conflict and a broader communication error.

If you find my answer useful, please mark it as the "Accepted Answer" so other members can find the solution easily. Your help in supporting the community is much appreciated!
Best regards,
Scott Nguyen

Answer 2

In Excel, negative numbers can be formatted to appear in red, but if they are not printing in red or not appearing at all, check both the cell formatting and any custom/conditional formatting being used.

To format negative numbers so they display (and print) in red using standard number formats:

1. Select the cells that contain the negative numbers.
2. Press Ctrl+1 to open Format Cells.
3. On the Number tab, choose Number or Currency in the Category list.
4. Under Negative numbers, select one of the red options (for example, a red negative with or without parentheses).
5. Print again and verify that the printer is set to print in color (not grayscale or black-and-white only).

If negative values are percentages and need to stand out:

1. Select the cells with the percentages.
2. On the Home tab, select Format > Format Cells.
3. On the Number tab, choose Custom.
4. In Type, enter a custom format such as: 0.00%;[Red]-0.00% This displays positive percentages normally and negative percentages in red.

If negative percentages should be in parentheses instead of a minus sign, use a custom format such as:

0.00%_);(0.00%)

If negative numbers are still not red or not visible when printing:

• Check for conditional formatting rules that might be overriding the font color or setting the font color to white on a white background.
• Confirm that the printer driver and printer settings are configured to print colors and not to convert everything to black or omit colored text.

---

References:

• Change the way negative numbers are displayed
• Format negative percentages to make them easy to find
• Format numbers as percentages in Excel