Question

To apply preset formatting designs to your worksheet data *
Table Styles
Theme Gallary
Both a and b
None of Above​

Answer 1

Answer:

Setting Up the Conditional Formatting

Start by deciding which column contains the data you want to be the basis of the conditional formatting. ...

Select the cell in the first row for that column in the table. ...

On the Home tab of the Ribbon, select the Conditional Formatting drop-down and click on Manage Rules….

Explanation:

Answer 2

Answer:

Auto Preview - Excel will automatically format your data range or table with a preview of any style you select, but will only apply that style if