 |
| 4 SMART Ways to use Custom Formatting instead of Conditional Formatting in Excel - Part 1 |
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)
Related Topics:
- Unusual use of Excel's Custom Number Formatting with Conditions and Symbols (Part 2)
- Convert Columns to Rows in Excel (NO Transpose, NO Formulas - SIMPLY UNPIVOT in Power Query)
- The QUICKEST and EASIEST Way to Work with TEXT in Excel
- Convert NUMBERS to WORDS (NO VBA) in Excel
- Better Excel Presentations: Increase Font Size of Formula Bar
Post a Comment