The following VBA code also can help you to remove the conditional formatting.ġ. To delete the entire worksheet conditional formatting, please do as follows:Ĭlick Home > Conditional Formatting > Clear Rules > Clear Rules from Entire Sheet, and the entire worksheet conditional formatting will be removed. And the selected conditional formatting has been removed. Click Home > Conditional Formatting > Clear Rules > Clear Rules from Selected Cells. Select the range that you want to remove the conditional formatting.Ģ. To delete the selected range conditional formatting, please do as this:ġ. Remove conditional formatting with VBA codeĮasily remove conditional formatting and background shading with Kutools for ExcelĬlear Rules function can help you quickly and easily remove the conditional formatting in selected range and entire worksheets. Remove conditional formatting with Clear Rules function How do you delete conditional formatting in Excel?

Microsoft Office should be completely removed.How to quickly remove conditional formatting in Excel?Ĭonditional formatting is a very useful tool in Excel, it can easily help you to format and shade cells according to specific conditional criteria, but sometimes you may want to remove or clear conditional formatting in Excel. Once the process is completed, go ahead and restart your system. You should have an option to select “Microsoft Office products” to remove Microsoft Office using the tool. Open the Microsoft Support and Recovery Assistant and follow the instructions as prompted.

The Microsoft Support and Recovery Assistant should work for any version of Microsoft Office (Office 2007, Office 2013, Office 2016, Office 365) on any modern version of Windows (Windows 7, Windows 8/8.1, Windows 10) Using Microsoft Support and Recovery Assistant (Formerly Microsoft Office Removal Tool)ĭownload the Microsoft Support and Recovery Assistant (Formerly Microsoft Office Removal Tool). If removing Microsoft Office this way doesn’t work or you want a cleaner un-installation, Microsoft also offers a less advertised Office Removal Tool that works much better. Normally, you’d remove Microsoft Office by going through Windows Programs and Features tool and using the Office un-installation utility. Chances are, you probably don’t want to remove Microsoft Office, but sometimes Microsoft Office decides to be a buggy mess and you may need to remove it for diagnostic purposes.

Office licence removal tool