Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/
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: https://youtu.be/FmHBpkscsZA
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/icons-conditional-formatting

Additional Resources:
Part 1 of 6: How to use the XOR Function: https://youtu.be/oe8oOmVRKOg
Part 2 of 6: How to use XLOOKUP for Reverse Order Search: https://youtu.be/5DAofCNCMb8
Part 3 of 6: Return Multiple Values for a Lookup Formula in Excel with FILTER and UNIQUE: https://youtu.be/ftDXUOKCaUM
Part 4 of 6: How to Sort with a Formula in Excel using SORT and SORTBY Functions: https://youtu.be/Li9awp2Hye8
Part 5 of 6: How to Create a Dynamic Drop-down List that Automatically Expands: https://youtu.be/Dt5ZRL5mXhk

Excel Hash: Attendance Report with Storm Clouds & Fireworks: https://www.youtube.com/watch?v=FmHBpkscsZA&t=30s
Attendance Report Dashboard for All Versions of Excel: https://www.youtube.com/watch?v=0aCx7OHh80U
2 Ways to Apply Conditional Formatting to Shapes: https://www.youtube.com/watch?v=o24yr9Oc7l0
How to Apply Conditional Formatting to Rows Based on Cell Value: https://www.youtube.com/watch?v=YAzK9vHa178&t=201s
How to Apply Conditional Formatting to Pivot Tables: https://www.youtube.com/watch?v=WwAV0gsJa0c&t=5s

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