In this step, change the “Decimal places” if you need.And then choose a type for the negative number.Now in the “Format Cells” window, click the “Number” in the “Category”.This is the same as the previous two steps And then in the menu, choose the option “Format Cells”.īesides, you can also directly click the small arrow in the “Number” area in the toolbar.After that, right click the selected area.In this example, we will select range C3:C13. Select the target area in the worksheet.In this method, you need to change the number format for certain cells. And in the coming article, you may learn about 3 effective methods. If you do this by changing the font color one by one, you will certainly spend a lot of time. To make things easier, you need to make all the negative numbers red. Suppose you are analyzing the sales volume of the last year. And in this article, we will demonstrate 3 useful methods to fulfill this task.
Sometimes you need to highlight negative numbers.
