How to Use Icon Sets with Text Values in Excel

How to Use Icon Sets with Text Values in Excel

For more Excel Conditional Number Formatting Tips and Tricks visit me at http://bradedgar.com



In this video I run a little longer than my 60 second threshold so I've added the + to my icon as you can see in my image.  That being said I tackle a few different things in this video.  

Custom Number Formatting Syntax Review:

[positive numbers; negative numbers; zero value; text]

Custom number formatting has sections for each type of number as displayed above.  Let's have a look how I use this in this video.


(1) I show you how you can take numbers and apply text values to them based on what the value is.  For example, if the value is positive, I'll show complete, if the value is negative, I will show behind and if the value is zero, I'll show on target.  You will get to go through each step that it takes to do this.

Notice I built a legend showing you that a value of 1 will show as complete, a value of 0 will show as on target and a value of -1 will be displayed as a negative.  

(2) Once we've applied the Excel custom number formatting, we can now move forward with applying our icons sets.  Icon sets in excel are a great feature for displaying how well something is performing.  In this video, we use icon sets with text values and custom number formatting to display icon sets with texts.  Because complete is assigned a value of 1 in our cells, on target a value of 0 and behind -1, we can use the numbers applied to the cells (even though they are being displayed as text) to apply icons.  Green icon sets will be applied a value of 1, Yellow icon sets a value of 0 and negative 1 will display in red.  

This is an excellent way to monitor and display status' in a visual way so that's easy to tell at what stage you are in your projects.  I'm sure you can think of a million other uses for it.

Here are a few other links and resources for you:

Excel Custom Number Formatting: How To Conditionally Format Text Fields With Icon Sets Using Number Formatting:

http://bradedgar.com/excel-custom-num...

5 Incredible Number Formatting Tricks That Will Impress Your Boss:

http://bradedgar.com/5-incredible-num...

How to Use Icon Sets in Excel:

http://www.excel-easy.com/examples/ic...

Excel conditional formatting Icon Sets, Data Bars and Color Scales:

https://www.ablebits.com/office-addin...

The Ultimate Guide to Custom Number Formatting:

http://jonvonderheyden.net/excel/a-co...

~-~~-~~~-~~-~
Checkout my newest video: "How to Use the Vlookup Formula in you Excel Dashboard"
How to Use the Vlookup Formula in you...
~-~~-~~~-~~-~

• #education
• #icon_sets
• #icon_sets_in_excel
• #conditional_number_formatting
• #use_icon_sets_with_text
• #bradedgardotcomexcel
• #excel_custom_number_formatting