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 ► https://www.linkedin.com/company/18737946/ Instagram ► https://www.instagram.com/computergaga1/ Twitter ► http://www.twitter.com/computergaga1