Question

Which command remove a conditional formatting

Answer 1

Explanation:

Remove Conditional Formatting With Clear Rules Function

Clear Rules function can help you quickly and easily remove the conditional formatting in selected range and entire worksheets.

To delete the selected range conditional formatting, please do as this:

1. Select the range that you want to remove the conditional formatting.

2. Click Home > Conditional Formatting > Clear Rules > Clear Rules from Selected Cells. See screenshot:

doc-remove-conditional-formatting1

3. And the selected conditional formatting has been removed. See screenshots:

doc-remove-conditional-formatting2

-2 doc-remove-conditional-formatting3

To delete the entire worksheet conditional formatting, please do as follows:

Click Home > Conditional Formatting > Clear Rules > Clear Rules from Entire Sheet, and the entire worksheet conditional formatting will be remo

Answer 2

Answer:

Explanation:

click home > conditional formatting > clear rules > clear rules from selected cells.