Converting conditional formatting into static

I've spent about a day searching high and low for some VBA code which will turn conditional formatting into static formatting but I'm not quite getting what I want.

The best I've managed to find is the code below, which is amazing in the sense that if there are more than conditional formats per cell it will pick the one that is true. HOWEVER, it doesn't work if the conditional formatting is based on a formula instead of it's cell value.

Anyone any ideas on how they can tweak the below?

Please Login or Register  to view this content.

Thanks for your time

I've just made a quick example,

1) If you have the conditional formatting as it is when you download it then it converts the first formula in the conditional formatting to a static colour but ignores the second conditional formatting formula
2) If you convert the conditional formatting to cell value and have yellow =1, green =2 then it will convert both to a static colour. I'm not sure why it won't do it with the formula option!!

Thanks for getting back to me

How can something so simple work so beautifully!?!!!!!?!!!!!!!!!!!!

I think you've done it, I just need to test it on the proper spreadsheet!!

I'll get back to you

Works like an absolute dream!!! Thank you so much

You are welcome and thanks for the rep