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

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

 

 

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. 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.

Related topics:

• Excel Picture Lookup: 5 easy steps for dynamic images
• Excel Slicer Trick - Use Symbols instead of Text in Pivot Slicers 
• 4 SMART Ways to use Custom Formatting instead of Conditional Formatting in Excel - Part 1
• Unusual use of Excel's Custom Number Formatting with Conditions and Symbols (Part 2)