//Add Gold Star Icons to Your Excel Reports

Add Gold Star Icons to Your Excel Reports

This post will teach you how to add gold stars to cells that meet a certain condition. In my example below, I want to highlight any cell that is greater than 90 for the customer service grade.

conditonal formatting Excel start

First I select the cells. Then I click the Home tab–>Conditional Formatting–>New Rule. I select Icon Sets from the Format Style drop down and 3 Stars from the Icon Style drop down. Next I change the percentage to number so that it reads Gold Star is when value is  >=90 Number. I select no cell icon from the other icons to block any other number from showing a half star.

gold stars cond formatting excel

The final output is displayed as.

tars conditional formatting excel

By | 2018-06-07T23:51:46-05:00 September 25th, 2017|Excel|0 Comments

About the Author:

Steve Chase grew up in Dayton, OH but now calls San Antonio, TX home along with his entrepreneur wife, Erin, and their 4 sons. Steve founded Sequentia Solutions in 2017 to help small business owners grow their business with practical and effective solutions. Steve's #1 Clifton StrengthsFinder skill is Learner which comes in handy while he teaches others how to best use various business software applications like QuickBooks Online and Excel. Steve is an active volunteer leader with the Boy Scouts and treasures the lessons he learned while participating in Scouts as a youth on his path to Eagle. Steve enjoys drinking coffee, a good book, visiting art museums, and doing math problems using a brand new sharpened #2 pencils.

Leave A Comment