# How to Make Negative Accounting Numbers Red in Excel – 3 Methods

The sample dataset contains monthly expenses, their amount and the balance after the expenses.

### Method 1 – Using Excel Conditional Formatting to Make Negative Accounting Numbers Red

STEPS:

Check that the negative data is in accounting number format.

• Select the data cells.
• Go to the Number Format in Number.
• Select Accounting.

• Go to the Home tab.
• In Styles, click Conditional Formatting.
• Select Highlight Cells Rules.
• Select Less Thanâ€¦

• In the Less Than dialog, enter 0, in Format cells that are LESS THAN.
• In with, select Red Text.
• Click OK.

• This is the output.

### Method 2 – Apply the Built-in Excel Number Formatting To Make Negative Accounting Numbers Red

STEPS:

Check that the negative data is in accounting number format.

• Select the data cells.
• Go to the Number Format in Number.
• Select Accounting.
• Go to the Home tab.
• Click the arrow icon in Number or pressÂ Ctrl + 1.

• In the Format Cells dialog box, click Number.
• Choose Currency in Category.
• SelectÂ  red color text currency.
• Click OK.

• This is the output.

Read More: How to Change Accounting Format in Excel

### Method 3 – Using a Custom Number Format to Make Negative Accounting Numbers Red in Excel

STEPS:

Check that the negative data is in accounting number format.

• Select the data cells.
• Go to the Number Format in Number.
• Select Accounting.

• Go to the Home tab and choose Number or press Ctrl + 1.
• In the Format Cells dialog box, select Custom in Category.
• Enter the following format in Type.
`\$#,##0_);[Red](\$#,##0)`
• Click OK.

• This is the output.

Read More: How to Center Accounting Format in Excel

Download Practice Workbook

## Related Articles

<< Go Back to Accounting Number Format | Number Format | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Sabrina Ayon

Sabrina Ayon, a Computer Science and Engineering graduate from United International University, has been an integral part of the ExcelDemy project for two years. She authored 150+ articles, excelling in instructing through visually engaging Excel tutorials. With a passion for teaching, Sabrina conducted sessions on Excel VBA, sharing her knowledge and insights with others. Currently holding the position of Project Manager for the ExcelDemy Visual Development Project, she oversees various aspects of the project, ensuring its smooth operation... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF