Go Back

Learn How to Remove Conditional formatting

You may have applied conditional formatting to cells to have a better understanding of the data. But at some point, you may also want to remove these conditional formatting. In this article we will help you understand how to remove conditional formatting.

Before you remove conditional formatting, the first step that you have to follow is to double check the points at which your conditional formatting is already applied. You should make sure that you want to remove conditional formatting from all the cells.  

Figure 1: remove conditional formatting

Explanation:

In figure 1 the conditional formatting is removed from all the cells of the excel sheet. The process is very simple. We will have to follow these simple steps to complete the task:

  • Click on the home tab
  • Click on conditional formatting
  • Click on clear rules
  • Click on clear rules from entire sheet

Following the above mentioned four tasks we can remove conditional formatting from entire cells.

If you want to remove conditional formatting or formula from just one cell at a time, you can simply right click on the cell and click on remove conditional formatting from the cell. Removing conditional formatting from each cell separately can be a very time-consuming process. This is the reason that removing conditional formatting is preferred by most of the users.

You can also remove conditional formatting from selected cells. This process is used when you want to remove conditional formatting from selected cells rather that entire sheet. For this process you should follow the following steps:

  • Click on the home tab
  • Click on conditional formatting
  • Click on clear rules
  • Click on clear rules from Selected cells

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:
Here are some problems that our users have asked and received explanations on

I am trying to remove the shading on alternate lines in my spreadsheet and can't seem to remove the conditional formatting.
Solved by G. B. in 24 mins
Conditional formatting
Solved by G. L. in 21 mins
Conditional Formatting Formula
Solved by S. Q. in 29 mins

Leave a Comment

avatar