FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -On the HOME tab, in the Styles group, click the arrow next to Conditional Formatting, and then click Manage Rules. The list of conditional formatting rules are displayed for the current selection including the rule type, the format, the range of cells the rule applies to, and the Stop If True setting.

Detailed explanation-2: -To create the first rule: On the Home tab, click Conditional Formatting > New Rule. In the Style box, click Classic. Under the Classic box, click to select Format only top or bottom ranked values, and change it to Use a formula to determine which cells to format.

Detailed explanation-3: -Click on the “Home” tab and then click “Conditional Formatting.” A menu will drop down containing several sets of preset rules that you can choose as well as options to create a new rule or edit existing rules.

Detailed explanation-4: -Apply Multiple Conditional Formatting Rules Select the cell or range to format and go to the Home tab > Conditional Formatting and choose a pre-defined rule from the menu or click New Rule at the bottom of the menu and make your own rule.