Home

Copying excel 2016 worksheet to new book

%3CLINGO-SUB%20id%3D%22lingo-sub-218715%22%20slang%3D%22en-US%22%3ECopying%20excel%202016%20worksheet%20to%20new%20book%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-218715%22%20slang%3D%22en-US%22%3E%3CP%3Ewhen%20I%20copy%20a%20worksheet%20to%20a%20new%20workbook%2C%20the%20colors%20I%20have%20used%20in%20conditional%20formatting%20change.%20Is%20there%20a%20way%20to%20avoid%20this%20or%20is%20there%20a%20way%20to%20copy%20the%20entire%20conditional%20format%20list%20from%20one%20workbook%20to%20another%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-218715%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-361831%22%20slang%3D%22en-US%22%3ERe%3A%20Copying%20excel%202016%20worksheet%20to%20new%20book%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-361831%22%20slang%3D%22en-US%22%3E%3CP%3Eis%20it%20because%20of%20a%20different%20color%20palette%3F%3C%2FP%3E%3CP%3Eyour%20original%20workbook%20and%20the%20target%20may%20have%20different%20palettes%3C%2FP%3E%3CP%3Eribbon%20%26gt%3B%20page%20layout%20%26gt%3B%20themes%20%26gt%3B%20colors%3C%2FP%3E%3C%2FLINGO-BODY%3E
Paul Weinberg
Occasional Visitor

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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies