From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 24,000 courses taught by industry experts.

Conditional formatting icons

Conditional formatting icons - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Conditional formatting icons

“

There are some conditional formatting icons in here, and they are wrong. That's where your help is needed. Let me first sort this by the count. Go to count, data, and I'm going to sort descending. We should have a full star for anything that's 40 and above, but minced garlic has a full star and it's only 31. Green olives is a 13, it should have a half star. So please get these corrected. Full star greater than, or equal to 40, half star greater than or equal to 13, empty star four counts that are less than 13. And then finally sort so that the half stars are on top. Right? Pause the video, get yourself some pizza, work this out, we'll convene back here and go through it. Let's get at it. Conditional formatting, manage rules. There's our rule icon set, we want to edit the rule. Slide this out of the way so we can see. A full star should be greater than or equal to 40. And you know what I'm going to do, here, hold on a…

Contents