Conditional formatting

[Alpacino]

How do I write vba for;
To clear all existing conditional formatting in range ("B5:H32") and leave font text/ numbers black

Thanks
Alan

 

[Andrew Poulsom]

Have you tried recording a macro while doing it manually?

 

[Alpacino]

Yeh but gives me loads of lines just like simple code

 

[Andrew Poulsom]

What does it give you?

 

[CharlesChuckieCharles]

I think if you can't extract what you need from the recorded macro -- you won't be able to support a provided vba answer

 

[Alpacino]

Got it trimmed it down now