Using Custom Formatting 1] Using Conditional Formatting In Excel, you can format a negative number by creating a Conditional Formatting rule. Select the range of cells containing the numbers.

There, you can see that negative numbers can be displayed in red, with or without the negative symbol. The Accounting number format, however, gives you less choice.