How To Remove Only Conditional Formatting in Excel

If you have applied conditional formatting to the data in an Excel Spreadsheet and you want to remove only the conditional formatting, keeping other formatting intact, then follow the below steps,

1. Open the Excel Spreadsheet.
2. Now select all the cells from which you want to remove only the conditional formatting.
3. Now under Home tab, click on the "Conditional Formatting" dropdown and go to Clear Rules -> Clear Rules from Selected Cells.
4. That's it!

Let's take a look at an example.

As you may see, I have conditional formatting in red color for the data where text is equal to the letter "a", and there are other cells highlighting with different colors but they are not conditional highlighting.

As you can see in the above screenshot, a post I cleared the rules from selected cells what remained is the normal highlighting.

Note: If you want to remove conditional formatting from the entire Sheet then choose "Clear Rules from Entire Sheet"

Human-Written Content: This article was demonstrated by a human, not AI.

Please support independent contributors like Code2care by donating a coffee.

Note: This example is demonstrated on Excel for Mac, but the process remains the same for Excel for Microsoft Windows as well.