How can I copy a conditional formatting from one document to another?

user2575413 picture user2575413 · Sep 19, 2014 · Viewed 118.3k times · Source

Google Spreadsheets can copy cell format to destination cell, but it seems "Conditional formatting" information didn't be copied.

Can we just copy the "Conditional formatting" from one document to another?

I know we can recreate it from the "Conditional formatting" dialog but it's really time consuming, whereas if we can just copy and paste, then it's fantastic.

Answer

Kornelius picture Kornelius · Mar 5, 2015

If you want to copy conditional formatting to another document you can use the "Copy to..." feature for the worksheet (click the tab with the name of the worksheet at the bottom) and copy the worksheet to the other document.

Then you can just copy what you want from that worksheet and right-click select "Paste special" -> "Paste conditional formatting only", as described earlier.