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: Data Validation
Using Data Validation – The Trigger Technique
If you don’t know about data validation yet, I suggest you read the following document before getting familiar with this method.
http://www.contextures.com/xlDataVal01.html
Data validation is certainly one of the best tools to perform what-if analysis, along with sensitivity tables. There many types of sensitivity analysis that can be performed with data validation. These can be used alone [...]
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.