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:

Icon Set Conditional Format

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:

No Cell Icon

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

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *