The one problem with icon sets is that they are always left-justified in the cell. Episode 923 will show you why this is a problem and how to overcome it.
This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Transcript of the video:
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
Basically, we start out with massive amounts of data.
So how are we going to analyze this?
Well, let's fire up a Pivot Table and see if we can solve this problem.
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
Yesterday, I talked about applying an Icon Set to a range, and that works great unless you have several columns of data.
So, here I have four columns of data, you'll see that when I apply the Icon Set-- so Conditional Formatting, Icon Sets, we'll choose one of the Icon Sets-- it appears to me that this red X applies to the 68, and it doesn't-- it actually applies to the 66.
They always left-justify the icon, which just drives me insane.
My initial reaction was, "Oh, we have to Center our numbers,” and I hate to Center the numbers because I like to have everything nicely aligned on the right-- so I'm going to undo that.
The one thing we can do is, there's a setting called Indent from the right.
So I'm going to use the dialogue launcher here in the alignment group, and we're going to use the right Indent, and then increase the Indent, maybe up to three or four, in this case, and, basically, then it's going to take those numbers and move them over from the right side of the cell; but it's still going to keep them aligned as if they're numbers-- it's not going to Center the numbers.
And it gets it actually closer to the Icon Set.
So, you know, an interesting way to, kind of, achieve the same effect, getting the numbers closer to the icon without moving the icon over.
It'd be nice if we could move the icon over, closer to the number; unfortunately, they just don't let us do this.
But using the right align and kicking that Indent up a little bit, allows us to solve the problem very, very easily.
Hey, I want I thank you for stopping by, we'll see you next time for another netcast from MrExcel.
Well, thanks for stopping by, we'll see you next time for another netcast from MrExcel.
Basically, we start out with massive amounts of data.
So how are we going to analyze this?
Well, let's fire up a Pivot Table and see if we can solve this problem.
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
Yesterday, I talked about applying an Icon Set to a range, and that works great unless you have several columns of data.
So, here I have four columns of data, you'll see that when I apply the Icon Set-- so Conditional Formatting, Icon Sets, we'll choose one of the Icon Sets-- it appears to me that this red X applies to the 68, and it doesn't-- it actually applies to the 66.
They always left-justify the icon, which just drives me insane.
My initial reaction was, "Oh, we have to Center our numbers,” and I hate to Center the numbers because I like to have everything nicely aligned on the right-- so I'm going to undo that.
The one thing we can do is, there's a setting called Indent from the right.
So I'm going to use the dialogue launcher here in the alignment group, and we're going to use the right Indent, and then increase the Indent, maybe up to three or four, in this case, and, basically, then it's going to take those numbers and move them over from the right side of the cell; but it's still going to keep them aligned as if they're numbers-- it's not going to Center the numbers.
And it gets it actually closer to the Icon Set.
So, you know, an interesting way to, kind of, achieve the same effect, getting the numbers closer to the icon without moving the icon over.
It'd be nice if we could move the icon over, closer to the number; unfortunately, they just don't let us do this.
But using the right align and kicking that Indent up a little bit, allows us to solve the problem very, very easily.
Hey, I want I thank you for stopping by, we'll see you next time for another netcast from MrExcel.
Well, thanks for stopping by, we'll see you next time for another netcast from MrExcel.
