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