Delete all conditional formatting and coloring conditional on specific rows

[Paul_Hossler]

What is the macro that you're using to call it?

I see there's a [Button1] on the worksheet

Maybe better to attach your actual workbook if you can