How To Make Negative Figures Red In Excel

26 Aug, 2021

But for some reports negative numbers must be displayed with parenthesis. From the Number sub menu select Custom.

Displaying Negative Numbers In Parentheses Excel

Because humans are better at processing colors than numbers its often a good idea to add some conditional formatting to your variances.

How to make negative figures red in excel. To highlight negative numbers in red you can either use conditional formatting so that the entire cells get highlighted in red or you can use custom number formatting so that the only the text is shown in red. Click Kutools Content Change Sign of Values see screenshot. Lets see how to do that.

And in the Change Sign of Values dialog box select Change all positive values to negative option. With the target cell s highlighted click on Format Cells or right-click Format Cells. You will now see various custom formatting styles.

You can select the number with a minus sign in red in parentheses or in parentheses in red. In the Number group click on the Format Cell dialog box launcher. In this Google Sheets tutorial I will cover both these methods to show the negative numbers in red.

Click Format Cells on menu. This is a time-honored way of formatting numbers as the sayings in the red and black Friday demonstrate. Right click on the cell that you want to format.

General means positive numbers -General indicates negative numbers Green Red are the font colors you want you can change the font color to your need. A common way is to mark negative variances to budget in red and positive in black. How to Show Negative Numbers in Brackets in MS Excel.

Alternatively press Ctrl 1 on the keyboard. On Format Cells under Number tab click Custom then under Type enter 0. In Excel the basic way to format negative numbers is to use the Accounting number format.

Click on Format Cells. And all of the positive numbers have been converted to negative. That produces the Format Cells screen see right.

In parentheses you can choose red or black In the UK and many other European countries youll typically be able to set negative numbers to show in black or red and with or without a minus sign in both colors but have no option for parentheses. Select the range you want to change. Show Negative Numbers in Bracket and in Red Color Select the cells which contain that list of the numbers as shown in the screenshot below.

Select the list contains negative numbers then right click to load menu. In black with a preceding minus sign. Scroll down and you will see something like.

In the Select Specific Cells dialog box select Cell in the Selection type section and then select Less than from. In the Format Cells dialog box click Custom from the Category list pane and then enter GreenGeneralRed-General0 into the Type text box see screenshot. Make all negative numbers in red with Kutools for Excel 1.

On the Number tab select the category Number and change the format to the second or fourth option negative numbers have red color and the. Select the range with the negative number you want to make in red then click Kutools Select Select Specific. This option will display your negative number in red.

Right-click on the cell and select Format Cells. Make All Negative Numbers Red by Format Cells Setting. Then click OK or Apply.

Go to the Home Tab. For example you can use Blue Yellow etc.

Formatting A Negative Number With Parentheses In Microsoft Excel