web 2.0


Excel 2010 No Cell Icon

Excel 2007 introduced Icon Sets to Excel Conditional Formatting. Excel 2010 introduces No Cell Icon to Conditional Formatting. In Excel 2007, after applying your Icon Set Conditional Format, you would get something like this:


Figure 1: Icon Set Conditional Format

The problem, of course, is that the whole this is a mess. If the idea is to identify poor grades, you’d need to create extra Conditional Formats so that you could hide the undesired icons. Excel 2010 introduces No Cell Icon which removes the need for extra formulas and extra Conditional Formats. Here’s how it looks like:


Figure 2: No Cell Icon

By choosing No Cell Icon, Excel 2010 will omit the icons for the selected conditions saving you all the hassle of extra conditioning:

 


Figure 3: Result after applying No Cell Icon

Tags: , ,

Microsoft Excel | Microsoft Office 2010

Comments are closed