Unusual use of Excel's Custom Number Formatting with Conditions & Symbols (Part 2)

Enhance your Excel skills with this in-depth tutorial on advanced custom formatting techniques. Ideal for Excel users seeking to create visually impactful and informative spreadsheets without relying on conditional formatting.

🌟 Key Learning Points:
- Understanding Custom Formatting: Learn the basics of custom formatting, including accessing it through the right-click menu and Format Cells option.
- Symbol-Based Deviation Indicators: Discover how to use custom formatting to display symbols (like arrows) to indicate data deviations, complete with color control.
- Font Tricks for Symbols: Explore using different fonts like Wingdings or Webdings to represent data symbols in Excel.
- Conditional Custom Formatting: Understand how to add conditions to custom formatting, allowing you to highlight significant data deviations.
- UniChar Formula for Symbols: Learn about the UniChar formula for accessing a wide range of symbols compatible with Excel's default font.
- Threshold-Based Formatting: See how to create custom formatting rules that only highlight data deviations beyond a certain threshold.

🚀 Practical Applications:
- Visually represent data changes or deviations with symbols and colors in Excel reports.
- Apply custom formatting to enhance data readability and interpretation without conditional formatting.
- Create dynamic Excel tables that automatically adjust formatting based on predefined rules.

Method #3: Use any symbol of your choice to show deviations and conditionally format these using custom formatting

Method #4: Use custom formatting to only show higher or lower deviations, i.e. use thresholds in custom formatting. The general custom formatting syntax that most are familiar with, is to format positive, negative, zero and text values. But you can also use custom formatting to format higher, lower and medium boundaries. In this video you'll see how that works.

🚩Let’s connect on social:

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!

#excel

[emilioriofrio]

Very useful. Thank you so much Leida for your time, effort and great energy!

[prathapkumargowdas]

Such an amazing and useful feature, I've learnt so much from your videos. The way you explain and everything is awesome. You are the best Leila.
Thanks again for such an great effort.

[JunGuwapo]

I just used this custom formatting to my reports to my clients and to my manager. They were all impressed! Thank you!

[fortune]

Liked the video even before I watched it! That's the kind of confidence your contents have won!

[savcam]

Thank you for bringing this functionality to my attention. You explained it very well and I learned something I had never thought of before. Excellent Job!

[rockstar]

Thank you so much. I've always wondered how Custom Formatting is done. Wow!

[sankyhariharan]

This is amazing! Thank you for sharing Leila. Must say, the way you explain is very easy to understand! You make learning interesting. Thank you.

[shironmania]

Thanks for taking us to an unexplored area in excel with so much utilities available in custom formatting...would be amply useful when implementing a user-defined colours or symbols

[panagiotis_papaioannou]

First of all, congrats on your channel. Great work!
One very useful feature which comes handy whenever you need to copy more than one symbol, number or even part of text, is the combination of the windows key + c to copy each one and then to use the windows key + v to choose from the clipboard which one(s) to paste in the cell.

[Rob.Martin]

Not just commenting on this video, but all I've seen so far. My understanding of excel has shot up a huge amount. I've learnt so much. Thank you.

[ScottAnders]

Great lesson, here, Leila! I can see a lot of cases where I'll be replacing conditional formatting with custom formatting, i.e. in tables. Thanks, again, for all of the helpful content on your channel.

[winnumber]

I used custom formatting for the first time the other day. It works so seamlessly! Thank you!

[tahirhanif]

You have made me into an excel ninja at work!
Thank you and God bless you.

[ApteryxRex]

Thanks for the tips ! I'd forgotten the [color#] conditions, & didn't know how to do the thresholds. The speed difference between custom formatting and conditional was enlightening.
An alternative to the copying the symbols is (using numeric keypad) ALT+30 for the positive variance and ALT+31 for the negative variance. This can be quicker method

Wow, I use conditional format before. Now I learn custom format. Thank you, Excel Queen👸!

[noumonmunir]

i barely knew anything about this and now with part 1 and 2 videos i'm way more knowledgable!

[alaala]

Much appreciated Leila. Thank you very much for new ideas

[hammadhumayun]

Amazing Video . Thanks for sharing . Will start practicing it at work in place of conditional formatting

[flaviobendl]

Excellent tool for reporting financial indexes. Thanks Leila.

[luisguichardo]

I was looking to improve my excel skills and the stetics at the same time. Im glad i found your chanel. greetings from Dominican Republic