Clearing Conditional Formatting
 

Is it possible to select a worksheet and clear its
conditional formatting without highlighting the actual
range that has the formatting? I know I can do:

Selection.ClearFormats

But this takes out everything.

Thanks

Clearing Conditional Formatting
 

No need to select the worksheet:

Worksheets("SheetName").Cells.FormatConditions.Del ete

HTH,
Bernie
MS Excel MVP

"ExcelMonkey" wrote in message
...
Is it possible to select a worksheet and clear its
conditional formatting without highlighting the actual
range that has the formatting? I know I can do:

Selection.ClearFormats

But this takes out everything.

Thanks

Clearing Conditional Formatting
 

Selection.FormatConditions.Delete

--

HTH

RP
(remove nothere from the email address if mailing direct)


"ExcelMonkey" wrote in message
...
Is it possible to select a worksheet and clear its
conditional formatting without highlighting the actual
range that has the formatting? I know I can do:

Selection.ClearFormats

But this takes out everything.

Thanks