Question

9. Write the step to Apply and Remove conditional Formatting.​

Answer 1

Answer:

To remove conditional formatting rules:

Select the cells that have conditional formatting.

In the Home tab, click the Conditional Formatting command. A drop-down menu will appear.

Select Clear Rules.

A menu will appear. You can choose to clear rules from the Selected Cells, Entire Sheet, This Table, or This PivotTable.

Answer 2

To create a conditional formatting rule:

• Select the desired cells for the conditional formatting rule.
• Selecting cells
• From the Home tab, click the Conditional Formatting command. A drop-down menu will appear.
• Hover the mouse over the desired conditional formatting type, then select the desired rule from the menu that appears. In our example, we want to highlight cells that are greater than $4000.
• The Conditional Formatting menu on the Home tab
• A dialog box will appear. Enter the desired value(s) into the blank field. In our example, we'll enter 4000 as our value.
• Select a formatting style from the drop-down menu. In our example, we'll choose Green Fill with Dark Green Text, then click OK.
• The Greater Than dialog box
• The conditional formatting will be applied to the selected cells. In our example, it's easy to see which salespeople reached the $4000 sales goal for each month.

To remove conditional formatting rules:

• Select the cells that have conditional formatting.
• In the Home tab, click the Conditional Formatting command. A drop-down menu will appear.
• Select Clear Rules.
• A menu will appear. You can choose to clear rules from the Selected Cells, Entire Sheet, This Table, or This PivotTable.