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
Improve Table Visualization using OFFSET and Conditional Formatting
Strong of our knowledge of the OFFSET function, here's a tip on how to use that function in combination with Conditional Formatting to make a table more legible by reducing clutter.
This tip can be applied on a table where the items of the main field are layed out on multiple lines, just like in the next picture.