Conditional Formatting in Excel can help you to highlight certain cells in range with colours. Conditional formatting with top bottom rules is an excellent way to visually rate data. The Excel Guru tells how to use conditional formatting Top Bottom Rules: 1) Top 10 items – Find top 10 items with Conditional formatting with top bottom rules 2)Top 10% - Find top 10% items with Conditional formatting with top bottom rules 3)Bottom 10 items - Find Bottom 10 items with Conditional formatting with top bottom rules 4)Bottom 10% - Find bottom 10% items with Conditional formatting with top bottom rules 5)Above Average - Find above average performers with Conditional formatting with top bottom rules 6) Below Average - Find below average performers with Conditional formatting with top bottom rules Highlighting cells with Conditional formatting can help you do you analysis very easily and quickly in excel. 10 Most Used Formulas MS Excel • 10 Most Used Formulas MS Excel Learn Basic Excel Skills For Beginners || Part 1 • Learn Basic Excel Skills For Beginners || ... 10 Most Used Excel Formula • 10 Most Used Excel Formula ☑️ *Most Imporant Excel Formuls Tutorials* Learn Vlookup Formula For Beginners in Excel • Learn Vlookup Formula For Beginners in Excel 5 Excel Questions Asked in Job Interviews • 5 Excel Questions Asked in Job Interviews ☑️ Create Speedometer Chart In Excel • Create Speedometer Chart In Excel Learn the Basic of Excel for Beginners || Part 2 • Learn the Basic of Excel for Beginners || ... Create Pareto Chart In Excel • Create Pareto Chart In Excel How to Create Dashboard in Excel • How to Create Dashboard in Excel ☑️ Excel Interview Questions & Answers • Excel Interview Questions & Answers ☑️