How to Make Negative Numbers Red in Excel 2010

When dealing with large spreadsheets in Excel 2010, it is important to be able to identify the information that is more important than the rest of the information. In some cases, such as a budget or a sales report, this could be situations where sales have decreased, or expenses may exceed income. Excel will handle negative numbers by placing a “-” sign in front of them, but you may find that this is not enough. Fortunately you can also adjust the formatting in your spreadsheet so that the numbers are automatically displayed with a red font.


Automatically Format Negative Numbers with Red Text in Excel 2010

Of course you could always go through and manually change the color of the text to red, but that is both tedious and prone to potential mistakes. The method described below is simple and automatic, and you can even choose to apply it to your entire worksheet so that additional negative number entries are formatted correctly. So continue reading below to learn how to make negative numbers red in Excel 2010.


Step 1: Open your worksheet in Excel 2010.


Step 2: Highlight the cells containing the information that you want to format with the automatic red font for negative numbers.

highlight the cells that you want to format



Step 2: Click the Home tab at the top of the window.

click the home tab at the top of the window



Step 3: Click the Format Cells: Number button at the bottom-right corner of the Number section of the ribbon.

click the format cells numbers button



Step 4: Select the Number or Currency option from the list at the left side of the window. Note that choosing the currency option will place a $ sign in front of any number in the spreadsheet.

click the number option under category



Step 5: Select the 1234.10 option under Negative numbers, then click the OK button.

select the option with the red font



When you return to your spreadsheet you will notice that all of your negative numbers are now displayed in red, like in the image below.

how to make negative numbers red in excel 2010


Do you have Netflix, Hulu, Amazon Prime or HBO? If you are looking for a simple way to watch these services on your TV, consider a Roku 3. They are easy to set up and among the most affordable video streaming devices available. Click here to learn more.

If you are printing a spreadsheet that is not going to fit on just one page, then it will be helpful to your readers if you re-print the column headers at the top of every page. Read this article to learn how. newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.