INSTRUCTIONS -
1. Use formulas to calculate Gross profit, Total operating expenses, Operating Income, and Variances in columns E & H.
2. Apply conditional formatting to columns E & H (ask yourself: why only those columns?). Don't forget to include a legend or key code for your conditional formatting.
3. Use those results to project what Austin's actual 2017 year-end results will be for Rev, CGS, R&D, S&M, Gen & Admin (column I). Include a brief rationale for each in column O.
4. Now apply conditional formatting to columns K, L & N.
And must also create a "HEAT MAP" From the results.
Attachment:- Assignment File.rar