How to use Conditional formatting in Excel - Data Bars for data analysis

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