Removing (clearing) the conditional formatting

To remove the conditional formatting from a specific range of cells:

1. start by selecting the range.

2. Click the “Conditional Formatting” button.

3. Choose “Clear Rules…” and then “Clear Rules from Selected Cells”.


To remove all the conditional formatting from the entire worksheet:

1. Click the “Conditional Formatting” button.

2. Choose “Clear Rules…” and then “Clear Rules from Entire Sheet”.