Color Numbers Based on the Value Result in MS Excel

• by Carol Bratt on 20080709 @ 09:53PM EST | google it | send to friends
• Filed under Carol's Corner Office | (related terms: color, red, negative, word, blue)

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 guide: Windows 8 Cheat Sheet: Touch and Mouse Gestures. Windows 8 brings a revolutionary way to use your mouse, touchpad, and touchscreen using 'gestures'. If you're new to gestures, you'll most certainly find them confusing - especially if you don't mean to invoke a gesture in the first place! That said, gestures are widely used on mobile and touch-based devices, and the technology is here to stay. Gestures can be a huge time-saver (similar to keyboard shortcuts) once you understand how to use them. For example, you can use gestures to move objects from one location to the next, zoom in, zoom out, enter passwords, and similar. This Windows 8 gesture cheat sheet is designed to make your life easier by demonstrating and explaining the basics. Print, share, and enjoy! Click here to download this guide now! Note: this guide 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.