macro to retain the conditional formatting result but to remove the rules behind

hi,

I'm enhancing my report which using a lot of conditional formatting (CF) rules and it causes increasing in the file size and slowness in opening the file.

i found a code, but it always read the CF as active whenever the cells had CF rules applied on it without checking whether the cells values met the conditional or not.

can anyone help to modify the code.

ex. cell (D:D) is the reference cell. if value for range (G7:L20) < reference cell, the font appear in red. otherwise, black.

Please Login or Register  to view this content.

the code seem working fine.. but i do not get the desired output..
ex: my reference value is 250.... when the cells value < 250, the font will be in red colour. whereas when it is greater than that, it will be in black (normal).. i just set one formatting rule that is when the cells value less than the reference cell, the font will be in red.

but when i ran the macro, all my cells font turn to red no matter the cells met the conditional rules or not....
that is my problem.