With Clear Rules, you can remove Conditional Formatting rules from the selected cell (s), an Excel Table, a PivotTable, or the whole worksheet. The plus point of using Clear Rules directly from the feature is knowing that the options will target just the Conditional Formatting rules., In this article, we will demonstrate 2 different ways to remove conditional formatting but keep the cell formats. To illustrate our methods, we’ll use the dataset below, which contains a sale list including the product name, unit price, and sale quantity., In this short tutorial, I will show you a couple of easy ways you can use to remove conditional formatting from a selected range of cells, the entire worksheet, or the workbook. I will also show you how you can remove specific conditional formatting rules while keeping the rest., By removing conditional formatting, you are essentially resetting the cells to their default format. Select the cells that have the conditional formatting you want to remove. When you select the cells, make sure you’re clicking and dragging to cover all of the cells with the formatting., In this tutorial, you will learn how to remove conditional formatting in Excel and Google Sheets. In Excel, you can remove conditional formatting rules for either selected cells or the entire sheet. Say you have a worksheet with numbers in Column B as shown below., Conditional formats, to Excel, are just like any other format. That means that you can delete them by simply deleting all the formatting in a cell. Follow these steps: Select the cell or cells whose formatting you want to delete. Display the Home tab of the ribbon. In the Editing group, click Clear | Clear Formats. That's it..