Copy Conditional Formatting Between Workbooks

Question

I have about 100 or so columns with multiple conditional formats applied to each column that I need to copy from one excel document to another. I've tried solutions from the Format Painter, to Paste Special, each failing to actually copy the conditional formats over. I hope I'm doing it wrong, as it would mean an easy fix for an otherwise, extremely long process (again). Is there any way to copy conditional formats from one workbook to another? I don't need to worry about copying over equations or cell values, just the formats.

Answer 1

Paste special > Formats would carry over the conditional formatting.

Try copying (Ctrl+C) and then paste special (Alt+E+S) and select Formats