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.
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.
3. Now on the tab Number type the following command
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.
- Perbedaan Ms.Office 2003 Dengan Versi Di Atasnya
- 19 Tutorial Bekerja Cepat Dengan Ms Excel
- Cara Gampang Menciptakan Barcode Di Ms Excel
- Cara Freeze Excel Lebih Dari Satu Kolom
- Tutorial Excel : Menciptakan Garis Scroll Pada Lembar Kerja
- Conditional Formatting Merubah Warna Sel Pada Kondisi Terbesar Atau Terkecil
- Cara Menghitung Sin Cos Tan Di Ms Excel Dengan Mudah
- Calculating Sin Cos Tan (Trigonometric Functions In Excel )
- Membuat Aplikasi Rangking/Juara Otomatis Di Ms Excel