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.
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.