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.

Clear Conditional Formatting Only from Selected Cells Excel

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.

Result of removing only conditional formatting

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"

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

Facing issues? Have Questions? Post them here! I am happy to answer!

Author Info:

Rakesh (He/Him) has over 14+ years of experience in Web and Application development. He is the author of insightful How-To articles for Code2care.

Follow him on: X

You can also reach out to him via e-mail:

Copyright © Code2care 2024 | Privacy Policy | About Us | Contact Us | Sitemap