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.
Step 2: 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.
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.
Step 5: Select the 1234.10 option under Negative numbers, then click the OK button.
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.
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.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.