In MS-Excel 2016, “Conditional Formatting” option is available in:
In MS-Excel 2016, “Conditional Formatting” option is available in:
(A) Insert menu
(B) Page Layout
(C) Formulas
(D) Home menu
Correct option is (D) Home menu. “Conditional Formatting” is located on the “Home menu or tab in Microsoft Excel. This tab is where you can find various formatting options such as font styles, alignment settings, borders and also the Conditional Formatting feature. It allows users to easily apply conditional formatting rules to cells and ranges within their Excel worksheets.