Tom’s Tutorials For Excel: Formatting Negative Numbers Red With Minus Sign

Tom’s Tutorials For Excel: Formatting Negative Numbers Red With Minus Sign

Absent from Excel’s standard negative number formats is one that colors negative numbers red with a preceding negative (minus) sign. You need a custom format to make the Before picture look like the After picture, as shown below.



Select the range of interest, right-click the selection, and click Format Cells.



In the Format Cells dialog box:
• Click onto the Number tab.
• In the Category list, select Custom.
• In the Type field, enter #,###;[Red]-#,###;0
• Click the OK button.

Share Button
Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , ,
14 comments on “Tom’s Tutorials For Excel: Formatting Negative Numbers Red With Minus Sign
  1. Dean Brown says:

    Thanks – works perfectly.

  2. Daanish says:

    Is there some way to bookmark that format?

  3. Chris says:

    Is there a way that this could be used with a decimal instead of whole numbers? ie. -.50

  4. Dan says:

    We did you put 0 at the end ?

    #,###.##;[Red]-#,###.##;0

  5. CO Bill says:

    Works great – – – many thank yous

  6. Sanjay says:

    i’m using the following formula, =IF(E55%,”p”,”t”&”u”)), to format cells using the wingdings3 font for up and down arrows. The formula works fine, but does someone know how I can change the color of the arrow? I need to create a distinct formulas per cell because sometime a positive value may mean a green arrow and sometimes it may mean a red arrow, hence I want to write a formula per cell.

Leave a Reply

Your email address will not be published. Required fields are marked *

*