Excel Conditional Formatting with Symbols and Icons (for better reports)

Jun 29, 2017 Excel Advanced Formulas & Features
This video shows you how how you can use your custom Symbols in Excel and conditionally format them to change color depending whether a condition is met or not.

Download the workbook here: http://www.xelplus.com/excel-conditional-formatting-symbols/

The video shows an example of a project timeline and how symbols can be added to notify you on weather the deadline is met in time, whether it's already over due and which tasks are still open.

You can use your own custom symbols in Excel and conditionally format them. You don’t have to choose between the icon sets available to you within Conditional Formatting, but instead choose pretty much any symbol you’d like and conditionally format this instead.

★ My Online Excel Courses ► https://courses.xelplus.com/

✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/

EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/

Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593

GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U

More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#MsExcel