Add Parenthesis to Negative Percentages; Add Brackets & Mark Red; Add Brackets, Minus Sign & Mark Red All Negative Percentages.
In this Excel tutorial, you are about to learn three sophisticated ways to display negative percentages in Microsoft excel.// We are going to use Cell Formatting to display negative percentages in red; in Red & parenthesis; also in red, parenthesis and with a minus sign in Microsoft Excel. You can apply this to all excel versions from Excel 10 to above. This tutorial is demonstrated using Excel 2019.

Check out our Last video on How to Mark Negative Percentage in Red in Microsoft Excel: https://youtu.be/5lz19Y0dR24

Here are the three Ways to format negative percentages In Microsoft Excel.
0:00 Different Formats Display Negative Percentages in Microsoft Excel
0:18 How to Format Negative Percentage in Parenthesis Without Minus Sign in Excel Using Cell Formatting
1:18 How to Format Negative Percentage in RED & Parenthesis Without Minus Sign in Excel
1:59 How to Mark Negative Percentage in Red in Microsoft Excel Using Conditional Formatting.

Before starting, I’d like you to look at these excellent Tutorials on highlighting and formatting numbers in excel:

How to highlight all negative numbers in red: https://youtu.be/58DiGqTF59Y
How to highlight all cells with negative numbers: https://youtu.be/vcXpWY4GY0E
How to identify or highlight upcoming expiration dates: https://youtu.be/FPm549l-byk

Now let’s follow the instructions to learn how to get parentheses for negative percentages in excel:
Step 1: Select the Data Range, where you have negative percentages.
Step 2: Right-click and select “Format Cells.”
Step 3: Select “Custom.” This is where you do custom formatting to your cells.
Step 4: Type: 0.00%;(0.00%)
Step 5: Click OK, and all the negative percentages are going to be displayed inside the parenthesis.
It is an excellent way to format negative percentages in excel. Though all the negative percentages are in brackets, you’ll be able to calculate it just fine. If you check the value, you can see the minus sign in the formula bar but not with the value in the cell. That means we didn’t change the value, but we formatted it and displayed minus to brackets.

Now, I’ll be using the Format cells option to format a range of negative percentages both in Red & Brackets. So, follow the steps below to display negative percentages in red and brackets in Microsoft Excel.
Step 1: Select the Data Range.
Step 2: Right-click and select “Format Cells.”
Step 3: Select “Custom.”
Step 4: Type: 0.00%;[Red](0.00%)
Step 5: Click OK, and all the negative percentages are going to be displayed inside the parenthesis, and the font color will be RED. This is how you can display negative percentages in red & within brackets in excel.

It is highly unlikely; you want to format negative percentages in red, within brackets along with the minus sign. Mostly if you Keep a value inside Brackets, it is considered as a negative value. The same goes for Red. Now, if you still want to display the minus sign along with red and parenthesis to your negative percentages, that is possible too. Follow the instructions below to format in such way in excel.
Step 1: Select the Data Range.
Step 2: Right-click and select “Format Cells.”
Step 3: Select “Custom.”
Step 4: Type: 0.00%;[Red](-0.00%)
Step 5: Click OK, and all the negative percentages are going to be displayed inside the parenthesis, and the font color will be RED, and there will be a minus sign inside the bracket also.

I have only used Custom formatting in this tutorial. The code used in the custom formatting is simple. The first part of the code (Before Semi-colon) resembles the positive percentages, and the second part of the code (After Semi-colon) resembles the negative percentages. You can add font color, brackets, minus sign or any symbol to percentages using this technique.

#Percentage #Brackets
Thanks for watching.
————————————————————————————————————-
Support the channel with as low as $5
https://www.patreon.com/excel10tutorial
————————————————————————————————————-
Please subscribe to #excel10tutorial
https://goo.gl/uL8fqQ

Here goes the most recent video of the channel:
https://bit.ly/2UngIwS

Playlists:
Advance Excel Tutorial: https://goo.gl/ExYy7v
Excel Tutorial for Beginners: https://goo.gl/UDrDcA
Excel Case: https://goo.gl/xiP3tv
Combine Workbook & Worksheets: https://bit.ly/2Tpf7DB
All About Comments in Excel: https://bit.ly/excelcomments
Excel VBA Programming Course: http://bit.ly/excelvbacourse

Social media:
Facebook: https://facebook.com/excel10tutorial
Twitter: https://twitter.com/excel10tutorial
Blogger: https://excel10tutorial.blogspot.com
Tumblr: https://excel10tutorial.tumblr.com
Instagram: https://www.instagram.com/excel_10_tutorial
Quora: https://bit.ly/3bxB8JG

Please take the opportunity to connect and share this video with your friends and family if you find it useful.