can i freeze conditional formating to copy to another worksheet
 

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?

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



Chris Lane wrote:

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