Question

write the steps to delete a condition formatting rule​

Answer 1

Answer:

In order to delete a conditional format, do this:

1. You want to select the range that you want to remove the conditional formatting.

2.  Then Click Home → Conditional Formatting → Clear Rules → Clear Rules from Selected Cells

$\textbf{ VBA remove code }$

Click Developer → Visual Basic, a new microsoft visual basic for applications window will be displayed, click Insert → Module

Input this following code:

↓↓↓↓

Sub DeleteConditionalFormats()

'Update 20130912

Dim Work-Rng As Range

On Error Resume Next

xTitleId = "KutoolsforExcel"

Set Work-Rng = Application. Selection

Set WorkRng = Application. InputBox("Range", xTitleId , Work-Rng. Address, Type:=8)

Work-Rng. Format-Conditions. Delete

End Sub

↑↑↑↑

All Done

Please disregard all of these symbols ( - ) and some spaces