Conditional Formatting vs Custom Formatting: Which is Best for Inserting Icons into Your Workbook?
In this video, we'll discuss the difference between conditional formatting and custom formatting, and how you can use each to insert icons into your workbook. We'll also show you some examples of how to use each method, so you can decide which one is right for you.
Understanding conditional formatting in excel is a great skill, and understanding custom formats can be even better. This video covers two methods of formatting icon sets in excel based on conditions - conditional formatting and custom formatting.
It shows you two methods: the first is how to use Excel's own conditional format icon sets to compare 2 columns (using excel conditional formatting arrows). The second method shows you how to create your own custom formats in excel and use any symbols, such as those in the wingdings font types. This gives you much better flexibility on what symbols you can format with so you can do conditional formatting with custom symbols.
0:00 Introduction
0:40 Conditional formatting icons
2:09 Why use custom formatting for icons?
2:43 Custom formatting icons
4:59 Adding colour to custom formatting
6:26 Additional benefits of custom formatting
6:51 Final thoughts
Learn Excel online for free: Our Excel for beginners tutorial will teach you all you need to know to take you from zero to Excel hero! Check out our extensive selection of beginners Excel videos
What Microsoft Excel tips and tricks do you want to learn? Let me know for future videos! I'll continue to develop tutorials covering Excel basics for beginners and will build up a catalogue of free Microsoft Excel course materials! :-)
Check out our other conditional formatting videos:
Introduction to conditional formatting: • Excel for beginners: CONDITIONAL FORM...
How to conditional format a row: • Excel for beginners: Conditional form...
