Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you'll get expert help in seconds

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.

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

Are you still looking for help with Conditional Formatting? View our comprehensive round-up of Conditional Formatting tutorials here.

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

Another blog reader asked this question today on Excelchat:

Leave a Comment

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co

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

Another blog reader asked this question today on Excelchat:

Post your problem and you'll get expert help in seconds

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc