How to Show Negative Numbers in Brackets and in Red in Excel (2 Methods)

Dataset Overview

We will use a dataset containing 10 numbers of which 3 are negative.

Dataset to Show Excel Negative Numbers in Brackets and Red


Method 1 – Using Excel’s Format Cells Option 

The easiest and quickest way to show Excel negative numbers in brackets and red is to customize the Number format.

Follow the steps below to do this.

  • Select all the cells in the dataset.
  • Right-click on your mouse button.

Access the Context Menu for Dataset

  • Choose the Format Cells… option from the Context Menu.

Choose Format Cells Option

  • The Format Cells dialogue box will appear.
  • Go to the Number tab >> choose Number from the Category pane >> choose the last option (1234.10) from the Negative numbers pane >> click OK.

Customize Number Format to Show Excel Negative Numbers in Brackets and Red

You will see all the negative numbers of your dataset in brackets and red color.

Excel Negatibe Numbers in Brackets and Red

Read More: How to Change Positive Numbers to Negative in Excel


Method 2 – Applying a Custom Format 

Another effective way to show negative numbers in brackets and red is to use the Custom Format.

Follow the steps below to do this.

  • Select the dataset and right-click on your mouse.

Right Click on the Dataset

  • Choose the Format Cells… option from the Context Menu.

Access to the Format Cells Dialogue Box

  • The Format Cells dialogue box will appear.
  • Go to the Number tab >> Custom option from the Category pane >> insert the following format in the Type text box:
#,##0.00;[Red](#,##0.00)

Proper Custom Format to Show Excel Negative Numbers in Brackets and Red

  • Click OK.

You will get all the negative numbers displayed in brackets and red color.

Excel Negative Numbers in Brackets and Red

Read More: How to Make Negative Numbers Red in Excel 


How to Show Excel Negative Numbers in Red Color with Conditional Formatting

You can also use conditional formatting to display negative numbers in red color but without brackets.

  • Select the dataset.
  • Go to the Home tab >> Conditional Formatting tool >> Highlight Cells Rules option >> Less Than… option.

Access the Conditional Formatting Tool

  • The Less Than dialogue box will appear.
  • Enter the value 0 in the Format cells that are LESS THAN text box.
  • Choose the Red text option from the with options.
  • Click OK.

Set Condition in Conditional Formatting

All the negative numbers in the dataset will be red in color.

Excel Negative Numbers in Brackets and Red

Read More: How to Add Brackets to Negative Numbers in Excel


Download Practice Workbook

You can download the practice workbook from here:


Related Articles


<< Go Back to Negative Numbers in Excel | Number Format | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Tanjim Reza
Tanjim Reza

Md. Tanjim Reza Tanim, a BUET graduate in Naval Architecture & Marine Engineering, contributed over one and a half years to the ExcelDemy project. As an Excel & VBA Content Developer, he authored 100+ articles and, as Team Leader, reviewed 150+ articles. Tanim, leading research, ensures top-notch content on MS Excel features, formulas, solutions, tips, and tricks. His expertise spans Microsoft Office Suites, Automating Finance Templates, VBA, Python, and Developing Excel Applications, showcasing a multifaceted commitment to the... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo