Question

Which formatting option will set a table with heading and assigns a different shade apart from the other cells.

Answer 1

Explanation:

Highlight Excel Cells Based on the Value of Another Cell

Select the data cells in your target range (cells E3:C14 in this example), click the Home tab of the Excel Ribbon, and then select Conditional Formatting→New Rule. ...

In the list box at the top of the dialog box, click the Use a Formula to Determine which Cells to Format option.

Answer 2

Answer:

conditional formatting option in the home tab

Explanation:

please mark me as a brain list please and follow me