» Color numbers based on the value result in Microsoft Excel
CATEGORY - Excel Format
VERSION - All Microsoft Excel Versions
There are two ways to color numbers according to criteria:
- Custom formatting for a number with criteria
- Conditional formatting
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

Book Store:
Recommended Books:
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Writing Excel Macros with VBA, 2nd Edition
- Microsoft Windows XP Step by Step (With CD-ROM)
- Absolute Beginner's Guide to Microsoft Excel 2002
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel
No comments have been submitted.

