You are here KNOWLEDGE Excel Tips Excel Text, Editing and Format Coloring Numbers Based on Specific Criteria

Query, Share and Manage Excel workbooks on LAN, Internet

Coloring Numbers Based on Specific Criteria

To color numbers, add criteria to the Custom Formatting:

Color positive and/or negative numbers in any desired color. (Do not get too excited – the number of colors is limited to eight, and most are difficult to read!)

For example, [BLUE] #,##0 ; [RED](#,##0)
• The first formatting section (before the first ;) refers to the formatting of positive numbers and is displayed in blue.
• The second formatting section (after the first ;) refers to the formatting of negative numbers and is displayed in red.
• The number 0 uses the positive formatting information (if there are two sections in the syntax) and is therefore displayed in blue.
• To add a condition to the formatting:
• Each section is displayed in a different color:
[BLUE] [5000]#,##0 ;[RED](#,##0); #,##0
Positive numbers above 5,000 are blue.
Negative numbers are red.
Positive numbers up to 5,000 (and 0) are black.
Screenshot // Coloring Numbers Based on Specific Criteria
Coloring Numbers Based on Specific Criteria