Jul 25 2018 01:34 AM
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?
Mar 06 2019 02:04 PM
is it because of a different color palette?
your original workbook and the target may have different palettes
ribbon > page layout > themes > colors