No Links were listed yet. Go ahead and share!
Hey, welcome back to the MrExcel netcast. I’m Bill Jelen. Here is a beautiful trick. I’ve got this from Mike Alexander. You know, Mike and I do the data in LS boot camp and I do the morning. He does the afternoon. I sit there in the afternoon and read emails and all of a sudden so I looked up and I saw this amazing trick.
Now, we’ve covered this one before where we can use a color in the number formats, so we go and look at this control one here and we have those different zones there, so we’re saying, “Hey, positive is green, negative is going to be red.” And what we get if it’s a negative number? You’ll get red, if it’s a positive number, you get the color that you used, but you know unfortunately, you’re limited to the eight colors or so I thought red, blue, green, cyan, yellow, black, white maybe magenta.
I don’t know, but Mike discovered that you’re not limited to those eight colors. You can use any of the 56 colors in the Excel color pallet. The way you do it is in the custom number format just specify in square brackets colors, space and a number from one to 56, and you’ll get those colors. I built them all down here, look all at all the different colors you can build in your custom number formats.
Very, very cool way to go, thanks to Mike Alexander for letting me steal that trick. Thanks to you for stopping well, see you next time for another netcast from MrExcel.
Transcription by:
Scribe4you Transcription Services