Two$-$Variable Data Table

a$)$ Next, create a data table with the result in cells F$24$:$131$ that shows Boston Four$-$Year Total revenues when the overall growth rate and Boston's adjusted growth factor are varied.

$1|$Page

b$)$ Use Conditional Formatting to highlight the row, Column and intersection for Overall Growth Rate, the Boston Adjustment Factor AND the corresponding Revenue Forecast on your two$-$variable data table, dependent on what is entered into cells H$4$ and H$6.$ For instance, if you enter $2\mathrm{.}25\%$ in cell H$4$ and $1\mathrm{.}75$ in H$6,$ Row $29$ and Column H in your data table should be highlighted.