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.