Excel Weekly News from Contextures Mar 04, 2014
Create colored Harvey Ball icons + more Excel tips
In this week's Excel news, you'll see how to create colored Harvey Ball icons, and other tips. Thank you for reading the Excel news!
- Debra ddalgleish@contextures.com
In Excel 2010, and later versions, you can use the built-in icon sets for conditional formatting, and choose specific icons from the available options. There are limitations to the color options though, so you can build your own.
This week, you'll see how to create a colored set of Harvey Ball icons, by using a custom number format (available in Excel 2010 and later).
Click here to see the details: Create Colored Harvey Balls in Excel
Did you know that you can accidentally create calculated items in a pivot table? In the screen shot below, Formula1 and Formula2 were added with a simple slip of the hand.
Here's how it happens, and how to remove any calculated items that you don't need.
Click here to see the details: Accidentally Create Calculated Items
You can create a drop down list in a cell, but if the source list has blank cells, they'll show up in the drop down. Use formulas to create a drop down list with no blanks cells.
Click here to see the details: Show Drop Down With No Blanks
Here are a few of the Excel articles that I read last week, that you might find useful:
When you create a drop down list in Excel, there is a check box for "Ignore Blank". This video shows an example of how to use that setting to prevent data entry problems.
Is it getting warmer where you live? Here in the Northern Hemisphere, we're looking for signs of spring, and an end to the frigid temperatures. I saw this old fashioned thermometer last week, that uses iodine to show when it's getting warmer. The dark purple crystals turn to a pink gas, when the temperature rises. I hope your forecast is rosy!
__________________________
Save time with our "Done For You" Excel products.
Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.
________________________
__
Contextures Inc., Copyright ©2019
All rights reserved.