hi,

The first step for learning to answer your own questions (& sometimes make it easier for potential helpers) should be to record a macro ([alt + t + m + r]) of the steps taken when you do whatever you do and then reviewing/tweaking the resulting code.

1)
In this case the relevant lines of code you would see are:
    Selection.FormatConditions.Delete 'just removes conditional formatting
'or
    Selection.ClearFormats ' removes all types of formatting
2)
Change "selection" to your required range & you should be all go...

hth
Rob