• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 119
  • Last Modified:

Pasting Conditional Format into a Range

I'm having a very weird problem in Excel pasting Conditional Formats. I have a conditional format in cell B2. If I copy and paste it into cell B3, it works fine. But if I copy B2 and paste it into a RANGE (say, B3 - B10) ALL cells from B4-B10 pick up the B3 conditional format, instead of each pasted cell picking up the correct references. These conditional formats involve Vlookups. But if one cell can paste to another, I don't get why it can't paste to a range.

Any assistance appreciated.
1 Solution
yes you need to change the formula you have what is the conditional format you have ?
Glenn RayExcel VBA DeveloperCommented:
You probably need to change the absolute cell referencing in the conditional formula to lock down the column and or row so that you can copy across ranges.  You could also just change the "Applies to" range in the Conditional Formatting rules manager.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now