How to clear  conditional formatting  in Excel worksheets

Excel 2007
Excel 2003
Macros Excel 2007
Macros Excel 2003
Excel 2010
Home

You can clear the conditonal formatting in Excel worksheets only after you have identified the areas of the worksheet where such formatting has been done. Another option is to use a check-box.
  1. Click in any area of your worksheet that has no conditional formatting applied, for example, any header
  2. Click on the Home tab
  3. Go to the Editing Group and click on the drop-down arrow next to 'Find & Select'
  4. Select the option Conditional Formatting from the drop-down menu
  5. We will notice that all the areas containing conditional formatting applied to them are automatically selected
  6. In the Home tab we can see a group called Styles
  7. Click on the drop-down arrow next to conditional formatting
  8. Hover your mouse over the clear rules from the visible menu 
  9. Now we are offered two options: Clear Rules from Selected Cells and Clear Rules from Entire Sheet
  10. You can select either of them
  11. The conditional formats will be removed
Watch the video below to see how the removal of formatting based on conditions is implemented:




Reference
Excel 2007 Excel 2003 Macros Excel 2007 Macros Excel 2003 Excel 2010
Home