Conditionally Formatted Icons Dashboard Part 6 of 6

Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint...
This video teaches you how to apply conditional formatting to the icons in Excel. The icons can appear a certain way when criteria are met, or look another way if they aren’t.
This is Part 6 of 6 in a series that shows you how to build a dashboard for an attendance report.
This dashboard was originally submitted as an entry in the Excel Hash competition:    • Excel Hash: Episode 2 - Learn How To Make ...  
If you’d like to see the accompanying blog post on my website, you can find it at this link: https://www.excelcampus.com/tips/icon...

Additional Resources:
Part 1 of 6: How to use the XOR Function:    • How To Use The Xor Function In Excel  
Part 2 of 6: How to use XLOOKUP for Reverse Order Search:    • How to use XLOOKUP for Reverse Order Search  
Part 3 of 6: Return Multiple Values for a Lookup Formula in Excel with FILTER and UNIQUE:    • UNIQUE & FILTER Functions Dashboard Part 3...  
Part 4 of 6: How to Sort with a Formula in Excel using SORT and SORTBY Functions:    • SORT & SORTBY Functions Dashboard Part 4 of 6  
Part 5 of 6: How to Create a Dynamic Drop-down List that Automatically Expands:    • Dynamic Drop-down Lists Dashboard Part 5 of 6  

Excel Hash: Attendance Report with Storm Clouds & Fireworks:    • Excel Hash: Episode 2 - Learn How To Make ...  
Attendance Report Dashboard for All Versions of Excel:    • Get Your Attendance Report Dashboard For A...  
2 Ways to Apply Conditional Formatting to Shapes:    • How To Apply Conditional Formatting To Sha...  
How to Apply Conditional Formatting to Rows Based on Cell Value:    • Conditional Formatting: Highlight Rows Bas...  
How to Apply Conditional Formatting to Pivot Tables:    • How To Apply Conditional Formatting To Piv...  

#MsExcel #ExcelCampus
00:00 Introduction
01:25 Creating the Icons
03:24 Grouping the Icons
10:35 Adding Text Boxes