Copying excel 2016 worksheet to new book

Copper Contributor

when I copy a worksheet to a new workbook, the colors I have used in conditional formatting change. Is there a way to avoid this or is there a way to copy the entire conditional format list from one workbook to another?

1 Reply

is it because of a different color palette?

your original workbook and the target may have different palettes

ribbon > page layout > themes > colors