6 Identify the square footage , base price , and total cost in
8.000 the data table that comes closest to their goal . Apply Blue , Accent 1 , Lighter 40 % fill color to those cells .
7 Copy and paste the square footage substitution values
12.000 in Table 1 to the range H6 : H15 . Remove the fill color . Enter these lot price substitution values in the range I5 : K5 : 90000 , 96000 , and 102675 , respectively . Format these values with the Accounting Number Format with zero decimal places and Blue font .
8 Enter the reference to the total estimated cost in the
12.000 appropriate location for the second data table . Apply a custom number format to display Total Sq Ft in that cell . Apply Blue font and bold to that cell .
9 Complete the second data table using the appropriate
10.000 input cells . Apply Blue , Accent 1 , Lighter 40 % fill color to the total price in each column that comes closest to their goal .