How to use Conditional formatting in Excel - Data Bars for data analysis
Channel: Efficiency 365 by Dr Nitin
Date: 05/07/2020

Understand conditional formatting in Excel to interpret data more easily. You will learn about customizing the appearance of Data Bars. Very useful tool for Visual data analysis. 

Answer to Quiz
------------------------------------------------------------------------------------------------------------------------
Quiz: How to highlight minimum and maximum value in data using Excel
Answer: Use Conditional Formatting
Steps:
1. Select data
2. Home tab - Conditional Formatting - Highlight Cells - Top/Bottom Rules - Top 10 Items
3. Change value of 10 to 1 - choose any formatting
4. Repeat the process with Bottom 10 - choose different formatting

Dr Nitin Paranjape 
Microsoft MVP 
Most Valuable Professional 
Read 1000+ articles on the blog by Dr Nitin Paranjape https://efficiency365.com