How to Make a Tutu for a Doll

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=AhtOvb3ZPwM

Microsoft Excel Tutorial: Can you use an Excel icon set for text cells? • Welcome to another episode of the MrExcel Podcast, where we explore all things Excel. In this episode, we will be discussing a question from one of our seminar attendees in Knoxville, Tennessee. Kristin asked if it was possible to apply icon sets to text, specifically for ratings. And the answer is yes, but with a few limitations. • If you were hoping to use icon sets for text and have more than three ratings, I apologize, this video may not be able to help you. However, if you have three or less ratings, then I have a super secret trick that can make it work. First, we will need to convert the text ratings to numbers, such as -1, 0, and 1. Then, we can use conditional formatting and icon sets to display the appropriate icons. But what about the text? That's where the custom number format comes in. By specifying different zones for positive, negative, and zero numbers, we can make the corresponding text appear. • But wait, there's more! In this episode, we will also explore how to use this trick for more than three ratings. By using a combination of conditional formatting, custom number formats, and multiple icon sets, we can make it work for up to five ratings. It may seem like a lot of steps, but it's worth it to achieve the desired result. And as always, if you want to learn more about Excel and its various features, be sure to check out my book, Power Excel with MrExcel. • So, to sum it up, can you apply conditional formatting icon sets to text? Yes, but with some limitations. If you have three or less ratings, you can use the trick in this episode to make it work. And if you have more than three ratings, don't worry, we have a solution for that too. By using a combination of conditional formatting, custom number formats, and multiple icon sets, we can make it work for up to five ratings. So don't let anyone tell you that something can't be done in Excel, because with a little creativity and some help from MrExcel, anything is possible. Thanks for watching and be sure to tune in for more Excel tips and tricks in our next episode. • Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ • You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-... • #excel • #microsoft • #microsoftexcel • #exceltutorial • #excelhacks • #evergreen • #conditionalformatting • This video answers these common search terms: • how to show text as an icon in excel • how to format as text in excel number • how to format number in text excel • how to format number to text in excel • how conditional formatting works in excel • how to conditional format text in excel • Table of Contents: • (00:00) Icon Sets for Text • (00:10) Icon sets on numbers • (00:20) Applying Icon Sets to Text Ratings • (00:42) Super secret way of using icon sets for 3 ratings • (00:52) Changing ratings to numbers and using VLOOKUP or IF statement • (01:05) Using Custom number format to replace numbers with words • (01:22) Applying Icon Sets Using Conditional Formatting • (01:32) Super secret trick for getting words to appear instead of numbers • (02:45) Limitation of Custom number formats for more than 3 conditions • (03:23) Wrap-up • (03:56) Outtake: Using 5 ratings and 5 icons with conditional formatting • (05:02) Handling 3 zones with Custom number format • (05:35) Using Conditional Formatting to format cells with 4 or 5 ratings • (06:00) Clicking Like really helps the algorithm • Kristin asks if you can add an icon set for Text cells? There are two workarounds in this episode. The first is for up to three icons. The outtake shows another way for five icons. • Can you apply Conditional Formatting Icon Sets to Text? • No • But, if you have three (or less) ratings, you can use the trick in this episode. • Convert your text ratings to 1, 0, and -1 • Apply the Icon set • Use a custom number format of positive ; negative ; zero • This will get words to appear instead of numbers • Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...

#############################

New on site