Color Numbers Based on the Value Result in MS Excel
A subscriber recently wrote me inquiring about having the number color in Excel change when there is a certain value result.
There are two ways to color numbers in MS Excel based on certain criteria:
- Custom formatting for a number with criteria
- Conditional Formatting
Your options for coloring a number in MS Excel are not limited to displaying negative number values in red. You can also color positive and/or negative numbers in any color you like. There is a limit to the colors however. There are only eight to choose from and the aren't really easy to read either.
Follow the steps below:
- To select the color, end the name of the color to the number format in brackets: [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] (RED](#,# #)); #,##0
Pretty cool huh?
When you become a member at CarolsCornerOffice.com, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!
Free eBook: Windows 7: Tips & Tricks. This eBook is for users that want to go one step further in their understanding of the Windows 7 operating system. With over 50 of the finest tips and tricks, this 113 page Windows 7 eBook features a plethora of screenshots, and was written especially for novices in mind. Also included is a bonus section for Windows 7 applications. Written and presented by technology enthusiast Vasu Jain. About the author: Vasu Jain is a software developer, web engineer, blogger, and Master's student at University of Southern California. He has written 2 other eBooks, including Office 2010 Tips & Tricks, and Developing apps for Windows 8. Click here to download this eBook now! Note: this eBook is free, but registration is required; after that, you can select more ebooks and videos for download without registering again. If you have questions / problems with the registration form, please read this.