All the cells of negative numbers will become red, while the positive numbers will remain the same. You can create your own custom format in Excel to highlight negative numbers. Select the range ...

Instead, you might want Excel to display negative values in red, or with parentheses, or both. Microsoft Excel provides two ways to do so: a format and a conditional format.

They work well for positive numbers but may struggle with negative values, often requiring additional rules or manual adjustments to display them correctly. Using Excel Auto Formatting as you Type ...

You can subtract numbers in Microsoft Excel in a few different ways, depending on your data and formatting.