Look Who it Was Random video

Excel Undocumented Hack - Use Icon Set For Only Good or Bad Records in Excel - Episode 925

356 views · Published 9 January 2009 · 2:12 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Use Icon Set For Only Good or Bad Records in Excel.

Welcome back to the MrExcel netcast! In this video, I will be showing you a cool trick to apply icon sets only to specific data in your Excel spreadsheet. We've been discussing icon sets all week, and now it's time to take it to the next level.

Have you ever wanted to highlight only the bad records in your data? Well, I'm going to show you how to do just that. We will be using the partial icon set feature to only show the red X for failing records, while leaving all other records without any icons.

To start, select the entire icon set and go to the CONDITIONAL FORMATTING menu. From there, create a new rule and select "highlight everything GREATER THAN 70". Then, choose the CUSTOM FORMAT option and select "nothing" as the format. This will ensure that no icons are applied to records with a value greater than 70.

Next, go to the MANAGE RULES option and select the rule we just created. Under the "STOP IF TRUE" option, check the box. This will prevent any additional rules from being applied to records that meet the criteria we set earlier.

The end result? Only the records with a value less than 70 will have the icon applied, making them stand out much better. This is a great way to customize your icon sets and only highlight the extreme values in your data.

I hope you found this tip helpful. Don't forget to subscribe to the MrExcel netcast for more Excel tips and tricks. Thanks for watching and I'll see you in the next video!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Apply icons only to the numbers that qualify for a red X. It is possible, but tricky. Episode 925 will show you how.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Table of Contents:
(00:00) Introduction to the topic of icon sets
(00:12) A cool trick for applying icon sets only to certain data
(00:22) Applying the icon set to only failing records
(00:32) Highlighting only the bad records
(00:42) Using a custom format to apply no icon
(00:54) Managing rules and using "stop if true"
(01:09) Explanation of the "stop if true" function
(01:26) Applying the icon set only to extreme values
(01:41) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Applying icons
Cell value greater than 70
Conditional formatting
Custom format
Highlight everything greater than 70
Highlighting bad records
Icon sets
Managing rules
Stop if true
Tweaking icon set

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152032/

More from this channel