$1)$ Format the spreadsheet by doing the following: $(10$ points$)$

Bold cells: D$5,$ D$9,$ D$14,$ D$16,$ D$27,$ D$29$

Indent cells, D$6$:D$7,$ D$10$:D$11,$ D$17$:D$26$

Apply a light blue background to cells: D$8$:P$8$; D$12$:P$12$; D$27$:P$27$; D$29$:P$29$

$2)$ In cell E$8,$ create a formula to calculate the total monthly income $($E$6$:E$7).$ Copy the formula to P$8.(15$ points$)$

$3)$ In cell E$12,$ create a formula to add the cost of goods and Job expenses $($E$10$:E$11).$ Copy the formula to P$12.(15$ points$)$

$4)$ In cell E$14,$ calculate the company$$s monthly gross profit, which is equal to the difference between the monthly income $($E$8)$ and the monthly cost of goods sold $($E$12).$ Copy to P$14.(15$ points$)$

$5)$ In cell E$27,$ create a formula to add the expenses $($E$17$:E$26).$ Copy the formula to P$27.(15$ points$)$

$6)$ In cell E$29,$ calculate the company$$s net income equal to the difference between its gross profit and its total expenses. $(15$ points$)$

$7)$ Apply conditional formatting to cells E$29$:P$29.$ If the value is a negative number change the font color to dark red. $(15$ points$)$

show step by step please and answers, thank youu