Learn how to highlight cells with negative values in Excel. Make negative numbers stand out in Red using Conditional or Custom Formatting.

Manage the display of positive and negative numbers with Microsoft Excel numeric formatting.

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.

But Excel gives you the option to dictate formatting for positive, negative numbers, and even 0.

How to Get Chart Bars to Show Red When the Value Is Less Than Zero in Excel?. When you create a chart in Excel using positive and negative values, both positive and negative graphs are the same ...

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