Friday, January 6, 2017

3 Tutorial How to Make Negative Numbers Show Up in Red in Excel

welcome friends selamt relearning to use Ms Excel. In this tutorial I will share a trick that will make Ms Excel worksheet you become more alive and will certainly become more booting up your work plus professional.

example 1


 example 2



of Example 1 we will make negative numbers turn red on the text alone, while the in Example 2 we made her cheel also change color. how this made? Let's look at two tutorial Ms Excel below.


1. How to create a negative value turns red with  Conditional Formatting

in these conditions we will determine or check the condition number, if negative value will be in the highlight color meraha or not. and here are the steps.

1. go to Home  → Conditional Formatting Highlight Cell Rules → → Less Than. you can see on the image below to facilitate  

2. Block all the cells you wish to change color if the negative conditions

3. appear well after the new window now give orders by entering the number 0 as batanan maximum number which will be changed to red, you can see in the picture below.

now all the numbers less than 0 will have a red color like the image below


============================================




2. How to create a negative value turns red with I nbuilt Excel Number Formatting


in MS Excel is already supplied many types of writing formats that can be used to automatically change the color of negative numbers to be red. 

1. block of data as young as you wish to change the color if it is negative or other value you specify

2. then go to  Home → Number Format group click on the small down drob in the lower right corner, you can see in the picture below.

3. On the Format Cells dialog, in the Number tab, select Number in the Category list. In the options on the right, select the red text in the 'Negative numbers'.

4. Click OK. of this tutorial will only change the text color is not a color Cells
============================================



2. How to create a negative value turns red with  Custom Number Formats.

well here's how to 3 that you can use to create negative values ​​turn red. in step 3, we make orders or its own code to color negative values ​​into the red on your Excel ms.

1. sepert previous steps cell block you wish to change wananya
2. then go to  Home → Number Format group  click on the small down drob in the lower right corner, you can see in the picture below.

 3. Now on the tab Number type the following command
General;[red]-General
 4. press ok
na as the previous step also from step 3 is juag will automatically give the red color in the cell is negative

thank you for reading my tutorial semoag benefit.


https://trumpexcel.com/negative-numbers-red-excel/


EmoticonEmoticon