Search Contextures Sites

 

Contextures
Newsletter Index

 

Contextures
Excel news
by email

 

 

 

Excel UserForms for Data Entry

 

30 Excel Functions in 30 Days

 

 

Contextures News

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

Create Colored Harvey Balls in Excel

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

Accidentally Create Calculated Items

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

Show Drop Down With No Blanks

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

More Excel Tips

Here are a few of the Excel articles that I read last week, that you might find useful:

  • Have you ever built a convoluted workbook, with formulas that make even your head hurt? John Rougeux shares his 3 Excel pro tips for helping others not hate you. 
  • Finally, for a humorous peek at what other people are saying about Excel, read this week's collection of Excel tweets, on my Excel Theatre blog.

Video: Ignore Blank Setting in Drop Downs

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.

Getting Warmer

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!

__________________________

Recommended Excel Tools

In addition to all the free Excel tips and tutorials, there are other Excel tools that you can invest in. To learn more about the products listed below, click on the links to take a look at their features, and decide if they're right for you.

Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.

________________________

Learn how to create Excel dashboards.

 

Privacy Policy

 

Contextures Inc., Copyright ©2014
All rights reserved.