There are two ways to color numbers according to criteria:
- Custom formatting for a number with criteria
- Conditional formatting
Using custom formats for numbers with criteria
Your options for coloring a number are not limited to displaying negative numbers red. You can color positive and/or negative numbers in any color you wish (do not get excited – the number of colors is limited to eight, and most are difficult to read). Do this by adding the name of the color to the number format in brackets.
Example: [BLUE] #,##0 ;[RED](#,##0)
A positive number is displayed in blue; a negative number is displayed in red; and 0 is displayed in blue (since there is no third section, 0 receives the format of the positive number by default).
Add a condition to the formatting, and have each section be displayed in a different color: [BLUE] [>5000]#,##0 ;[RED](#,##0); #,##0 Screenshot // Color numbers based on the value result in Microsoft Excel