Create a 5 Star Rating System in Excel

In this video, we create a 5 star rating system in Excel using Conditional Formatting.

The formula below is used in the video to calculate what star is needed in each cell.

=IF($B2*=I$1,1,IF(INT($B2)=I$1-1,MOD($B2,1),0))

Use the greater than sign in place of the asterisk. The asterisk is used as angle brackets are not allowed in video descriptions.

Conditional Formatting is then applied to these cells to show the star ratings.

Find more great free tutorials at;
https://www.computergaga.com

** Online Excel Courses **

The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm

Connect with us!

LinkedIn ► LinkedIn: 18737946
Instagram ► Instagram: computergaga1
Twitter ► Twitter: computergaga1

• #howto_style
• #star_rating_system
• #5_star_rating
• #conditional_formatting
• #microsoft_excel
• #computergaga
• #5_star_rating_in_excel
• #excel_dashboard
• #conditional_formatting_in_excel
• #excel_star_rating
• #excel_rating_system
• #excel_ratings
• #excel_dashboard_tutorial
• #excel_survey_analysis
• #excel_reporting_and_analysis
• #excel_reports_and_dashboards
• #excel_reports
• #alan_murray
• #excel_for_analysts
• #star_rating_in_excel
• #excel_formulas_and_functions
• #dynamics_graphs_in_excel