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:

I would say its closer to "formatting that is applied automatically based on a rule related to a specific condition" and "grouped based on a rule

formatting that is selected for each cell"

Correct me if I'm wrong but for me that's close

only #2 represents an object at rest on a table.

in #1, there is no normal force due to the table; the object is accelerating downward.

in #3, the vertical forces are not balanced; the object is accelerating downward.

in #4, neither the vertical nor the horizontal forces are balanced. the object is accelerating upwards and to the right.