How to Make All Negative Numbers Red in Excel 2013

Storing and analyzing data in Excel is something that almost every business will need to do. Whether you are tracking product sales, revenue, or website statistics, Excel provides a useful means for looking at, editing, and sorting that information.

Occasionally some values in your spreadsheet will be negative, and they are likely formatted with a preceding “-” to indicate that the number is read. But if you are simply reading that data, it can be very easy to misidentify a negative number as a positive number. One helpful way to minimize the risks of this occurring is to make all of the negative numbers in a row or column red. Our guide will show you how to apply red formatting to negative numbers in Excel 2013 to make those negative numbers stand out amidst the positive numbers that surround them.

 

How to Automatically Format All Negative Numbers with Red Text in Excel 2013

The steps below are going to show you how to format your selected cells so that any negative numbers displayed within those cells will display with red text.

Step 1: Open your spreadsheet in Excel 2013.

 

Step 2: Select the column letter, row number, or group of cells containing the numbers that you would like to format with red text.

select the cells to format with red negative numbers

 

 

Step 3: Right-click any of the selected cells, then click the Format Cells option.

how to format negative numbers with red text in excel 2013

 

 

Step 4: Click the Number option under Category at the left side of the window.

switch cells to number formatting in excel 2013

 

 

Step 5: Select one of the red text options under Negative numbers, then click the OK button.

how to make negative numbers red in excel 2013

 

 

Any negative numbers in your selected cells should now be red. If there are decimal places after your numbers and you don’t want them there, simply return to the menu in Step 5 and change the value in the Decimal places field to 0.

red negative numbers in excel 2013

 

 

Are you trying to print your spreadsheet, but it’s difficult to read on a printed page? Read our guide to printing from Excel and learn about some really useful settings that can make printing your spreadsheets a lot easier for you and the people that read those spreadsheets.