How to override conditional formatting in Excel

Formatting is a very crucial aspect of Word editing. You can bold, underline, italicize, set paragraphs, etc. using well-arranged commands and shortcuts. Formatting is also tenable on Excel. There are several formulas and procedures in formatting work on your Excel spreadsheet. You can condition your cells to respond automatically when you press a particular key or enter a cell's value. For example, your cells can turn red whenever you type '0' in the cells. That's how conditional formatting works. However, you may wish to override or stop the conditional formatting. Before then, the following are the vital things you should know about conditional formatting.

All the spreadsheets obey the conditional formatting. The automatic functionality will continue when you hide or lock the columns.

Conditional formatting is also known as an auto-filling formula. It is effective when the regulated conditions are met. However, the overriding of the automatic changes does not have any effect on the excel performances.

If you no longer want to maintain the conditional formatting, you can override the functions by using the options below:

Using Clear Rules

Let's use the following data as an example

As you can see the duplicates above have been highlighted using conditional formating.

You can simply click undo to override conditional formating

Alternatively highlighted the data>click on conditional formating

Select Clear rules>Clear rules from selected cells

Using Clear Contents

1. Check your toolbar and locate the formatting buttons. You can as well use the shortcuts on the keyboard to apply the formats in a different way.

2. Type your values on a formula

3. The next step is for you to remove all the contents in the cell. Go ahead and right-click and select "clear cell contents."

4. Applying the autofill, quickly check the toolbar and click "undo." Please note that you will not find the undo command after saving the sheet.