Comments on: How To Use Google Sheets Copy Conditional Formatting [3 Easy Methods]

By: Sumit

Sumit — Mon, 19 Dec 2022 02:09:34 +0000

In reply to Vako. We addressed this in the update, but there is no easy way to do what you're saying. The easiest way would simply be to reapply the rule through the conditional formatting menu.

By: Tom

Tom — Mon, 13 Jun 2022 13:00:02 +0000

Wanted to bandwagon off of Vako’s comment and reiterate: I’m looking for a paste/copy option that also automatically changes the cell nomenclature and not just append the range of the original rule. Right now, Sheets just appends the end of the rule to include the new range, which creates major formatting issues across a large sheet.

I’m not saying the author needs to write about this, just putting this here for any future visitors having the same issues.

By: Vako

Vako — Fri, 15 Oct 2021 15:40:02 +0000

Thank you very much for this info.
The only issue with this is that if you have a formula, it doesn’t change the cell numbers when you do Past Special or Paint.
e.g.: If I have a Custom Formula Is option with a reference to a cell, when I copy that to another location, it should change the cell number depending on the location copied to.

If you have a solution for this scenario, please let us know. Thank you.

By: ChessWind

ChessWind — Fri, 11 Jun 2021 05:39:11 +0000

Super useful! Thanks a bunch <3