Hey! Welcome back to the Mr. Excel netcast. I am Bill Jelen. Basically, we’ll start out with massive amounts of data. So, how are we going to analyze this? Well, let us prior up the activity table and see if we can solve this problem.
Hey! welcome back to the Mr. Excel netcast. This week, we have been talking about Excel 2007 and the Icon sets under conditional formatting. So normally, you choose an icon that—and it just going to distribute the icons in equal fashion. So, that way within the data set, it is going to basically break it into in this case not quartiles but thirds. So, we want to have some control over that. If we go into conditional formatting and say that we want to manage rules, we will see the Icon set that was set up. Were going to choose that Icon set and click edit rule. And here, we actually get absolute control. So, we can say that we do not want to do based on a percent, we want to do based on number. And we can say we want the green anytime that were at, let us say 90 and above. The yellow will come in for 70 and above and then the red X comes under 70. So, this is some sort of a grading scale or something like that, we click Ok. Click Ok. And now, we have really changed the format so can see the people that have A’s, have the green checkmark, the people that are failing or close to failing. And I’m going to have the red X and everyone else would be in C’s. So, they’re just kind of in the yellow range.
So, a lot more power when you go into manage rules. You can actually change the various settings on how to build your own ranges rather than just allowing Excel to apply range. I kind of like this. They let get into an Icon set very, very quickly. But if you need more control, you can go in and find more control.
I want to thank you for stopping by. We’ll see you next time for another netcast from Mr. Excel.
Transcription by:
Scribe4you Transcription Services