can i freeze conditional formating to copy to another worksheet

[Guest]

I have a worksheet with conditional formating (red, green or no-fill) to
highlight data. I want to copy the data and the cell colour to another
standalone spreadsheet. I know it is possible to replace a formula with its
result. Is there some way to achieve the same effect for the conditional
formating before I copy to the second sheet?

 

[Dave Peterson]

One way if the range is small is to copy that range, paste into MSWord and then
copy from there into the other worksheet.