Pasting Conditional Format into a Range

Posted on 2014-08-28
Last Modified: 2014-09-05
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.
Question by:Buck_Beasom
    LVL 29

    Expert Comment

    yes you need to change the formula you have what is the conditional format you have ?
    LVL 27

    Accepted Solution

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    After several days of searching and hunting for limited documentation, I wanted to share this guide to hopefully save someone the hassle of trying to figure this out on their own. I have tested this on Xendesktop 7.1 and PS 4.5 running simultaneous…
    The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
    Viewers will learn the basics of the new Quick Analysis feature in Excel 2013.
    Viewers will learn how to share Excel data with others from desktop Excel, as well as Excel Online via OneDrive, and embed an Excel file on a website.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now