Identify the square footage, base price, and total cost in the data table that comes closest to their goal. Apply Yellow fill color to those cells.

Complete the single variable data table in the range D5:F15. Be sure to use total square footage as the column input. Apply custom number formats to display Base Cost in cell E5 and Total Cost in cell F5. Apply these formats to the headings: bold, center, and Blue font color.
Identify the square footage, base price, and total cost in the data table that comes closest to their goal. Apply Yellow fill color to those cells.
Copy the square footage substitution values, range D6:D15 to the range H6:H15 and remove the fill color. Enter these lot price substitution values in the range I5:K5: 90000, 96000, and 102675. Format these values with Accounting Number Format with zero decimal places and Blue font color.
Enter the reference to the total estimated cost in the 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.