How to Remove or Delete Conditional Formatting in Excel
This post will guide you how to remove Conditional formatting style in your worksheet in Excel. How do I delete conditional formatting with vba macro in Excel 2013/2016.
Assuming that you have a list of range which contain product data, and those cells have been highlighted by conditional formatting function. And if there is a easy way to remove conditional formatting quickly in the selected range of cells in your worksheet. This tutorial will show you two methods to remove conditional formatting.
Method1: Remove Conditional Formatting
If you want to remove the conditional formatting quickly in the selected range of cells, and you can do the following steps:
Step 1: select the range of cells that you wish to remove the conditional formatting.
Step 2: go to Home tab, and click Conditional Formatting command under Styles group. select Clear Rules menu from the drop down menu list, and then click on Clear Rules from Selected Cells.
Step 3: you would see that the conditional formatting rules have been removed in the selected range of cells.
Method2: Remove Conditional Formatting with VBA Macro
You can also use an Excel VBA Macro to quickly remove conditional formatting in the selected range of cells. Just do the following steps:
Step1: open your excel workbook and then click on “Visual Basic
” command under DEVELOPER
Tab, or just press “ALT+F11
” shortcut.
Step2: then the “Visual Basic Editor
” window will appear.
Step3: click “Insert
” ->”Module
” to create a new module.
Step4: paste the below VBA code into the code window. Then clicking “Save
” button.
Sub RemoveConditionalFormatting() Set myRange = Application.Selection Set myRange = Application.InputBox("please select a Range:", "RemoveConditionalFormatting", myRange.Address, Type:=8) myRange.FormatConditions.Delete End Sub
Step5: back to the current worksheet, click on Macros
button under Code
group. then click Run
button.
Step6: you need to select one range of cells that you wish to remove conditional formatting, such as: range A1:A5.
Step7: let’s see the result: