MrExcel's Learn Excel #923 - Icon Set Alignment

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on Jan 7, 2009.
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!
maxresdefault.jpg


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.
 

Forum statistics

Threads
1,213,543
Messages
6,114,243
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top