can i freeze conditional formating to copy to another worksheet

C

Chris Lane

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?
 
D

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.
 
Top