Show Negative Numbers in Red Color (with a Bracket) in Excel

In this video, I will show you how to show negative numbers in red color and/or with brackets.

This can be done using two methods:
-- Conditional Formatting
-- Custom Number formatting

Once you decide the format and apply that format (negative numbers showing in red and in bracket), it would automatically be applied to all any changes that happen.

This video is a part of my 'Excel is two-minute' series, where I share simple and quick tips to help you speed up your work and be more efficient

This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website). This channel is meant for people who want to learn Excel.

It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc. Please subscribe to this channel to be the first to know when new Excel tutorials come out.

⚙️ Gear I Recommend:

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial

[jerrytai]

Thank you! It’s very useful!!! Big cheers!!! Very clear explanation 😊

[renaldoschutte]

This was so useful, thank you for keeping it so simple.

[yefaobeng]

Really useful the part when you explain how the formatting works. Thank you!

[wayneedmondson]

Hi Sumit.. thanks for the video. Custom number formatting is so powerful and useful. Thanks for sharing your tips. Thumbs up!

[noufal]

Useful. Thank you . how can we add thousand separator comma in this format ?

[meetkcs]

Excellent, very nice option.

How you r exploring such a micro level options.

Wonderful.

[monisharaj]

Fantastic ... after 2hrs... i found it

[sportsmusiclover]

Thanks so much. But how do you remove the decimals from the numbers once you apply the 'GEneral;' custom addition?

[HimanshuKumar-frmo]

Pls make video on how to apply sum, multiplY, divide formula on the cell contains TEXT..BTW ..all your videos are awesome!

[bheemappabellad]

plz guide me how add the numbers out of bracket separately and within the bracket separately.
my data in a1, a2, a3 are given below. how can I get the dynamic answer 6(4) in a4 cell. plz explain.
ex: 2(1)+3(1)+1(2)=6(4)

thank u sir

[AS-uzgf]

Excellent Video. I need a doubt. How to append the decimals inside the bracket ie., (100.00), (200.00) etc., If I click comma (, ) icon, (-200) convert into -200.00.

[umeshchandarana]

There are Dr. And Cr. I want all Cr. ( Credit ) to be shown as negative. How can I do so ? Please guide.

[Turnivor]

The thing is, i want to have the following format, but excel keeps excluding the - and places it OUTSIDE the brackets. How can i include the - INSIDE the brackets?

The end result should be like this: (-1.29%) for decreases and (2.15%) for increases

[PintuKumar-fowh]

I want text instead of number how to apply formula

[kimberleebillows]

Microsoft won't allow me to do this formula. It keeps stating to use a selected one below.