From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Apply conditional formatting icons

Apply conditional formatting icons - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Apply conditional formatting icons

“

- [Instructor] Ready for some more conditional formatting? I hope so. All right, we've got this list of members, goals were set, and then we have their actuals. Then a percentage of their goal was calculated and then a statement about whether they fell short, met goal, or exceeded, and the definition of falling short, meeting goal, or exceeding goals, that is in the range I4 to J6. We'd like to make this a little more visually interesting and that's where your help is needed. Can you go into the percent of goal column and insert conditional formatting icons to show if a person fell short, met, or exceeded their goals, and the fun part is you get to pick the icons. You're going to need three of 'em, all right, so get those inserted. Come back and I'll show you a solution. Okay, let's insert some icons. I'm going to highlight this data range. Go to conditional formatting. Icon sets. More rules, so the greater…

Contents