An easy way to visualize data in a table

This case study is answering a request for a broker to help in getting an easy way of calculating the transaction costs and the brokerage fees. If the first part is easy as you only need to apply a few formulas and pay attention to the cell reference types you are using, the Sensitivity Analysis table was more complex.

In the example below, we have a calculation of the total costs based on the possible multiples applied to the deal. As you can see, the company is applying 2 different multiples: one for Accounting and one for the Financial Planning of the deal. 

The challenge now, after fixing the initial formulas, is how to make the data found at the intersection of the selected multiples stand out. And how to make this automatically, without a need of manually adjusting the highlight colors in the row and columns headers, nor for the cell showing the total deal when taking the specific multiples into consideration.

Registered members will see more and get free access to the files.