Let's take a look at icon sets icon sets allow you to divide your data into groups of 345. So from the Home tab, Conditional Formatting icon sets. So the way it works is if you pick one with three, it will break it into the top third, middle, third, lower third. Pick one with five, I'll break it into fits. So just start off, pick the one that you like the best. Like that.

And then, if you want it to change up the rules, click conditional formatting, Manage Rules. With your set, selected, edit rule off the current selection. And you can see right here is the percentages. So first, if you're going to do an absolute kind of rule, change it to number and then we're going to say 90 or higher is a green and we're going to say anything less than 60 is going to be a red X, okay? If you desire, if you had a desire to change up the icons, you could come in here and select at what you might want here. And that's possible to do that and so forth.

So I could do something like that. And then when you're done, hit OK. Apply. See, if you like it, then if you do, click OK. And there we go. So now, little legend, we might want to create a quick legend. You know, so it's 90 or higher.

Between 60 and 90, and then less than 60. Okay, so just do just some quick numbers here. Let's say 9575. We won't see these after we're done here. See if we can use the Format Painter. Just to get the requirements and then the trick is to go back into the conditional formatting, Manage Rules, edit rule, and check show icon only.

And that's how we can have a quick legend off to the side there. Okay, awesome. So, love that rule. That's icon sets, find it in the conditional formatting, icon sets, divider there.