4 SMART Ways to use Custom Formatting instead of Conditional Formatting in Excel - Part 1
Custom formatting is really easy to use once you understand the rule behind it.
Download the workbook here: http://www.xelplus.com/smart-uses-of-custom-formatting/
For Part 2 watch: https://youtu.be/faPSXNkU1Y0
We normally use custom formatting to show numbers with thousand separator, as percentage or even to show green for positive and red for negative values. Basically to format the numbers in our reports. But we hardly ever use custom formatting to show deviations with symbols. Or to disguise our numbers to look like symbols instead. The trick is super simple.
In this video, I show you a simple way of showing variances using symbols - up/down arrows or any symbol of your choice - with Excel's custom formatting. All you need to know is the rule behind custom formatting - i.e. first argument is how positive numbers should be formatted, then how negative numbers should be formatted, followed by how zero values should be shown and last text. Custom formatting can be confusing, but if you remember this simple rule, you're all set. I cover this also in my free PDF eBook which you can get from my website (see link below)
Why would you want to use custom instead of conditional formatting?
1. Your files will process faster.
2. It's super easy to setup!
This video belongs to a 2 part series. This is part 1 of 2. In the next video, I will show you how you can add thresholds to your deviations using custom formatting.
VBA code from Excel MVP Charles Williams to time your formulas is included here: http://bit.ly/2q1fpSK
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ 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
Time Stamps:
00:00 Why Use Excel Custom Formatting over Conditional Formatting
04:02 Basics of Excel Custom Formatting
08:05 Up/Down Arrows for Deviations with Excel Custom Formatting
12:32 Up/Down Arrows and Percentage Deviations with Excel Custom Formatting
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/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
Видео 4 SMART Ways to use Custom Formatting instead of Conditional Formatting in Excel - Part 1 канала Leila Gharani
Download the workbook here: http://www.xelplus.com/smart-uses-of-custom-formatting/
For Part 2 watch: https://youtu.be/faPSXNkU1Y0
We normally use custom formatting to show numbers with thousand separator, as percentage or even to show green for positive and red for negative values. Basically to format the numbers in our reports. But we hardly ever use custom formatting to show deviations with symbols. Or to disguise our numbers to look like symbols instead. The trick is super simple.
In this video, I show you a simple way of showing variances using symbols - up/down arrows or any symbol of your choice - with Excel's custom formatting. All you need to know is the rule behind custom formatting - i.e. first argument is how positive numbers should be formatted, then how negative numbers should be formatted, followed by how zero values should be shown and last text. Custom formatting can be confusing, but if you remember this simple rule, you're all set. I cover this also in my free PDF eBook which you can get from my website (see link below)
Why would you want to use custom instead of conditional formatting?
1. Your files will process faster.
2. It's super easy to setup!
This video belongs to a 2 part series. This is part 1 of 2. In the next video, I will show you how you can add thresholds to your deviations using custom formatting.
VBA code from Excel MVP Charles Williams to time your formulas is included here: http://bit.ly/2q1fpSK
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ 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
Time Stamps:
00:00 Why Use Excel Custom Formatting over Conditional Formatting
04:02 Basics of Excel Custom Formatting
08:05 Up/Down Arrows for Deviations with Excel Custom Formatting
12:32 Up/Down Arrows and Percentage Deviations with Excel Custom Formatting
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/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
Видео 4 SMART Ways to use Custom Formatting instead of Conditional Formatting in Excel - Part 1 канала Leila Gharani
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![Unusual use of Excel's Custom Number Formatting with Conditions & Symbols (Part 2)](https://i.ytimg.com/vi/faPSXNkU1Y0/default.jpg)
![Uncover Windows 10 Most Useful Features Today](https://i.ytimg.com/vi/do06MPWf9E4/default.jpg)
![10 Super Neat Ways to Clean Data in Excel](https://i.ytimg.com/vi/e0TfIbZXPeA/default.jpg)
![Excel Pivot Tables EXPLAINED in 10 Minutes (Productivity tips included!)](https://i.ytimg.com/vi/UsdedFoTA68/default.jpg)
![Excel Conditional Formatting in Depth](https://i.ytimg.com/vi/aomParo6vZ0/default.jpg)
![Excel IF Formula: Simple to Advanced (multiple criteria, nested IF, AND, OR functions)](https://i.ytimg.com/vi/KkTaQ5OjAGc/default.jpg)
![Conditional Formatting Rows Based on Another Cell Value](https://i.ytimg.com/vi/YAzK9vHa178/default.jpg)
![Excel Conditional Formatting using Formulas](https://i.ytimg.com/vi/QS0LnutUSs4/default.jpg)
![Excel DGET Function Solves 2 of Your VLOOKUP Problems](https://i.ytimg.com/vi/57MARBvYVs4/default.jpg)
![Excel shortcut keys you SHOULD know!](https://i.ytimg.com/vi/Xe4U_-o_EWw/default.jpg)
![This Excel Chart will grab your attention (Infographic template included)](https://i.ytimg.com/vi/C9beIaL-cBA/default.jpg)
![Pivot Table with Progress Chart and Dashboard](https://i.ytimg.com/vi/cTl3rPLP1cE/default.jpg)
![Create Multiple Dependent Drop-Down Lists in Excel (on Every Row)](https://i.ytimg.com/vi/7mo4COng7Sg/default.jpg)
![50 Ultimate Excel Tips and Tricks for 2020](https://i.ytimg.com/vi/FXs3WG7M-qk/default.jpg)
![Why you SHOULD be USING Custom Number Formatting in Excel](https://i.ytimg.com/vi/68Tet_8BNB8/default.jpg)
![Progress Circle Chart in Excel as NEVER seen before!](https://i.ytimg.com/vi/ZN3pEt_h7eg/default.jpg)
![SUPER EASY Excel Data Entry Form (NO VBA)](https://i.ytimg.com/vi/cNpFB8M1-dI/default.jpg)
![How To... Use Basic Conditional Formatting with an IF Statement in Excel 2010](https://i.ytimg.com/vi/tgPS7p9Sqtk/default.jpg)
![Return Multiple Match Results in Excel (2 methods)](https://i.ytimg.com/vi/fDB1Ktyhp3Y/default.jpg)
![4 Hidden Excel Dashboard Design Tips for Beautiful Reports](https://i.ytimg.com/vi/p2bFHuAR8Z0/default.jpg)