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: Rakesh
Author Info:

Rakesh is a seasoned developer with over 10 years of experience in web and app development, and a deep knowledge of operating systems. Author of insightful How-To articles for Code2care.

Follow him on: X

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