This can be done in so many ways, but I will show you the most flexible way that you can use – defining a formula for the rule, so you can apply that for any other formatting that you need.
How to perform conditional formatting? Select values where you want to apply the formatting and click the triangle in the Conditional Formatting, in the Home tab. I created a table like this (you don’t have to do the formatting things). Just open Excel and type in some values (make sure to have positive and negative ones). We do not need some complex Excel files to show how this is done. Read More 3 Ways to Make Negative Numbers Red in Excel 1) Using Conditional Formatting
