Share this blog
The Financial Modeler- Conditionnal Format Controls – Part Deux
- Spotting Errors
- How to Model Depreciation
- Improve Table Visualization using OFFSET and Conditional Formatting
- OFFSET Function Tutorial
- Getting More From Your Pivot Tables
- Conditional Formats Control – The Warm-Up
- Improve your model now! #REF Editions
- Back to School – The Excel Model
- R1C1 Enlightenment
Tag Archives: Controls
Conditional Formats Control – The Warm-Up
Conditional formats is a wonderful feature that incrementally adds format to a cell based on some criterias. You could use it to highlight cells by adding a color fill, changing borders or modifying any other format element.
In it’s basic form, you can use it with a simple condition depending on the cell value. However, a [...]
Posted in Excel Functionality, Model Techniques Also tagged Conditional Format, Error Handling Leave a comment
Conditionnal Format Controls – Part Deux
In this post, I'll show you how I like to use Conditional Formatting in my Excel models to add a disabled look to some cells based on a criteria. With this technique, you will get clear visual indications that will simplify inputs and help you avoid errors.