Variant 2 (Advanced Model)
This section follows the same pattern as the last, and explains how to create the 0702_Indicators_02.xlsx file. It focuses in particular on its dynamic elements, namely controls, formulas, and conditional formatting. Note that this section is limited to a discussion of the elements of this file that clearly differ from those of variant 1 of the model as discussed in the previous section (i.e., the basic version in the 0701_Indicators_01.xlsx file). For the following discussion, I assume that you’re already familiar with the information provided there.
On the Companion CD
Open the \Samples\0702_Indicators_02.xlsx file on ...