Last updated on May 11th, 2023
Estimated reading time: 3 minutes
Clear Rules function can help you quickly and easily remove the conditional formatting in selected range and entire worksheets.
If you are new to conditional formatting in excel refer our article Conditional Formatting in Excel – Full Stack Tutorials Hub .
Remove / Clear / Delete conditional formatting in Excel
Click Home > Conditional Formatting > Clear Rules > Clear Rules from Selected Cells.
First and easy Method: –
Remove conditional formatting with Clear Rules function
- First: Select the cells that have the conditional formatting that you want to remove.
- Second: Click on the Home tab > Conditional Formatting
. - Third: Click on Clear Rules
- Fourth: Select the option from drop down list of clear rules functions from selected cells / Entire Sheet / this table.
Second Method: –
Remove conditional formatting with Manage Rules
- First: Select the cells that have the conditional formatting that you want to remove.
- Second: Click on the Home tab > Conditional Formatting .
- Third: Click on Manage Rules
- Conditional Formatting Rules Manager Dialog box will open.
- In Show formatting rules for, there are two options.
- Current Selection (Auto Option)
- This worksheet
- Forth : Click on Delete Rules
- Fifth : Click on Ok or Apply