How to replace conditional formatting

[sharpeye]

Hello everyone, Im a first time poster here although I have found a few solutions Ive needed from this site so I thought I'd sign up to see if anyone can help me this issue.

I have a spreadsheet that gets more data added to it daily, it has a lot of nity little feateures but as the size of it grows, the more my laptop slows down when pasting new rows or running sorts etc.

Ive been having a look around a few forums and Ive come to the conclution that all my conditional formatted cells are the root cause of this and I was wondering if theres a quick was to replace the conditioanl formatting with the result of the conditional formatting, for example,

if cell a1 > 2 cell b2 turns green, if a1 < 2 then b2 turns red

so what im looking to do is find all the cells that contain a green as the result of a conditional format and replace it with a plain simple green instead which im hoping will reduce the resources my laptop uses.

I want to continue to use the condtional formatting to get my colours assigned but once the colours are assigned, I just need the cells to stay that colour once it has been assigned as after that it will never need to change.

I hope ive explained everything ok.

Many thanks

 

[Peter_SSs]

Welcome to the MrExcel board!

I haven't tested it, but you could see if this thread helps.

 

[sharpeye]

The code posted in that thread works like a dream, thanks for directing me to that thread

=)

 

[Peter_SSs]

Cheers, glad it helped.