Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 116
  • 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.

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

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