Baixar "SMART Ways to use Custom Formatting instead of Conditional Formatting in Excel - Part 1"

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. In this video, I will show you simple ways of showing deviation/difference using symbols (arrows or any symbol of your choice) - with Excel's Custom Formatting. Rule behind custom formatting: 1. First argument is how positive numbers should be formatted, then 2. How negative numbers should be formatted, followed by 3. How zero values should be shown and last 4. Text Formatting. Custom formatting can be confusing, but if you remember this simple rule, you're all set. Download the workbook from here: https://docs.google.com/spreadsheets/d/1IbYnbyJCdeyk-2K1i7smqYd6ZHuIWegK/edit#gid=1784296087 For Part 2, watch this: https://www.youtube.com/watch?v=pqWRB4iSVaI For Color Changes: https://learn.microsoft.com/en-us/previous-versions/office/developer/office-2007/cc296089(v=office.12)?redirectedfrom=MSDN -------------------------------------------------------------------------------------------------- GEARS Used: ○ Microphone: https://www.amazon.in/gp/product/B076B8G5D8?ie=UTF8&camp=3638&creative=24630&creativeASIN=B076B8G5D8 ○ Tripod: https://www.amazon.in/gp/product/B082GCRJVX?ie=UTF8&camp=3638&creative=24630&creativeASIN=B082GCRJVX -------------------------------------------------------------------------------------------------- YouTube: https://www.youtube.com/c/myexcelclub?sub_confirmation=1 Facebook: https://www.facebook.com/unsupportedbrowser Website: https://myexcelclub.com -------------------------------------------------------------------------------------------------- FREE VBA Tutorials for Beginners (Learn VBA in less than an hour!) https://www.youtube.com/playlist?list=PLnUatmTSNNhRP8x5YcEUK55JtBhp700UH * Top 10 Most Useful Excel Tips & Tricks: https://myexcelclub.com/10-most-useful-excel-tips-tricks/ * Excel Shortcuts: https://myexcelclub.com/top-50-excel-shortcut-keys/ * Top 45 Excel Functions: https://myexcelclub.com/excel-functions/ Happy Learning! #MyExcelClub Note: This description contains affiliate links, which means at no additional cost to you, I will receive a small commission if you make a purchase using the links. This helps support the channel and allows me to continue to make videos like this. Thank you for your support!