When I copy and "paste the conditional formatting only" option from one column to another (e.g. A1:A5 to B1:B5) the result is that for B1:B5 the conditional format range includes A1:A5.

How can I paste the conditional formatting to have a standalone range that only includes B1:B5? (excluding the laborious way of redefining it).

  • Welcome. Please remember that as per site guidelines when an answer addresses your question, you should accept it so others can benefit as well. You can even upvote the answer. If you don't have enough reputation, your upvote will show up later, once you reach enough reputation points. Apr 29, 2023 at 17:55

1 Answer 1


First use the copy command Edit-->Copy
You can then use a special paste for this as shown in the image.

Edit-->Paste special-->Conditional formatting only

paste the conditional formatting only

  • Yes that is known, but does not cause: "to have a standalone range that only includes B1:B5" ; for it will also include A1:A5 into the range. May 1, 2023 at 6:34
  • "for it will also include A1:A5 into the range" It will and it makes perfect sense. Because - since you paste a new range- it will include both ranges. May 5, 2023 at 15:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.