No text or picture Add-ons were added yet. How sad!
Hey, welcome back to Mr. Excel netcast. Yesterday, I talked about applying an icon set to arrange. And that works great unless you have several columns of data. So, here I have four columns of data and you’ll see that when I apply the icon set so conditional formatting, icon sets will 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 a really nicely aligned on the right so, I’m going to undo that.
The one thing we can do is the setting called indent from the right. So, I’m going to use the dialogue launcher here on 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 still going to keep them aligned as if their numbers is not going to center the numbers. And it keeps actually closer to the icon set. So, it’s an interesting way to kind of achieve the same effect getting the numbers closer to the iPod without moving the icon over. It would be nice if we could move the icon over closer the number. Unfortunately, they just don’t let us do this but using the right align and kicking that indent up a little bit. It allows us to solve the problem very, very easily.
Hey, 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