can i freeze conditional formating to copy to another worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
One way if the range is small is to copy that range, paste into MSWord and then
copy from there into the other worksheet.
 
Back
Top