Keep CF Colour

[MicJag]

Hi there, I wonder if someone can help me, i've been looking all over but cant seem to find my answer i have a worksheet that i need to copy paste to another workbook sheet but there is allot of conditional formating colors i would like it to paste with it? there is 5 different colors and some sheets could have more than 10 000 line's so manually changing the colors can be somewhat time consuming... any help will be much appreciated

 

[Weaver]

There was some serious macro code published on this messageboard that could turn CF colours into normal (ie not conditional) formatting. If you can find that and apply it to your sheet before you copy/paste, you should get the results you need.

 

[MicJag]

There was some serious macro code published on this messageboard that could turn CF colours into normal (ie not conditional) formatting. If you can find that and apply it to your sheet before you copy/paste, you should get the results you need.

Thanks a Mill! i found it and it works great