VBA to "freeze" conditional formatting

[ste23]

I've seen VBA written to do this for excel 2003 but not for 2007. All i want to do is to make the fill colour and font colour of the CF permenant so the CF can be deleted.

I have a spreadsheet which is being crippled by conditional formatting. As i write this i've been waiting 10mins just to delete 10 columns! The CF has worked great and gives the results i wanted. however, it makes the file far to large to work with and i want to "freeze" to CF fill colours.

Thanks in advance