How to use Conditional formatting in Excel - Icon sets for data analysis
Channel: Efficiency 365 by Dr Nitin
Date: 2020-07-03

Understand conditional formatting in Excel to interpret data more easily. You will learn about managing rules and customizing the appearance of Icon sets. Very useful tool for Visual data analysis. 

00:00 - Intro
00:07 - Data 
00:30 - Choosing Conditional Formatting
00:58 - How excel interpret's Data
02:09 - Changing Targets
02:30 - How to see only low values
03:00 - Show Icons only - without data (better for presentations)
03:40 - Conclusion

Read detailed article on Conditional Formatting by Dr Nitin  here 
https://efficiency365.com/2014/05/27/i-know-you-are-not-interested-but-still-high-medium-low-in-depth/
Dr. Nitin Paranjape
(MVP)