Conditional formatting removal

[sharpeye]

Hello everyone.
I have seen the answer I am looking for before but it was a long time ago and after searching I couldnt find the solution I need so apologies if this is a duplicate.

I have a sheet that uses a lot of conditional formatting, coloured cells and coloured font with a few formulas as well.
What I'd like to find out is how to remove all the formatting and formulas from sections of my worksheet but the cells remain the same format, same colours, same font colours etc.

Thank you ever so much in advance
=)

 

[Peter_SSs]

I have seen the answer I am looking for before but it was a long time ago and after searching I couldnt find the solution

Looks like it could well be related to this: convert conditional formatting into standard one

 

[sharpeye]

Looks like it could well be related to this: convert conditional formatting into standard one

I think thats the one, it even has a post from me in the thread, maybe I should have looked at my previos posts to find it lol

 

[Peter_SSs]

You're welcome.

I think thats the one

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.

BTW, I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)