Question

which statement describes what the conditional formatting option in excel 2016 allows users to do? it automatically applies formatting based on specific rules or conditions being met. it automatically applies highlighting to selected cell ranges based on specific rules or conditions being met. it automatically changes the font of selected cell ranges based on specific rules or conditions being met. all of the options listed are correct.

Explanation:

Conditional Formatting in Excel 2016 can apply formatting (which includes highlighting, changing font etc.) based on rules/conditions. So all the listed options about its capabilities are correct.

Answer:

All of the options listed are correct.