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.

Answer 1

All of the options listed are correct.

Conditional Formatting in Excel 2016 automatically applies formatting (such as fill/highlighting, font changes, borders, etc.) to selected cells when specified rules or conditions are met.