 |
| Unusual use of Excel's Custom Number Formatting with Conditions and Symbols (Part 2) |
In this video I share two more ways you can use custom formatting instead of conditional formatting in Excel. 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.
Related Topics:
Post a Comment