Confirm the My table has headers box is enabled. Confirm the data field contains =$A$3:$F$10. In the Format As Table pop-up window, do the following: Under the Medium section, click Dark Red, Table Style Medium 7.Ĥ. On the Home tab, in the Styles group, click Format as Table to open the gallery.ģ. On the Organic Feed worksheet, select cell range A3:F10.Ģ. Apply the Dark Red, Table Style Medium 7 format.ġ. Project 2/7 - Task 4 On the Organic Feed worksheet, format the data range A3:F10 as a table that has headers. Select Clear Rules and click Clear Rules from This Table. On the Home tab, in the Styles group, click Conditional Formatting.ģ. On the Feed Inventory worksheet, click anywhere on the table.Ģ. Project 2/7 - Task 3 Remove the conditional formatting from the Inventory column on on the Feed Inventory worksheet.ġ. In the Insert Hyperlink pop-up window, click Remove Link.

On the Insert tab, in the Links group, click Hyperlink.ģ. On the Feed Inventory worksheet, select cell C27.Ģ.

Project 2/7 - Task 2 On the Feed Inventory worksheet, remove the hyperlink functionality but leave the text in cell C27.ġ.

Excel 2019