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?
is it because of a different color palette?
your original workbook and the target may have different palettes
ribbon > page layout > themes > colors