+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting Copy & Paste

  1. #1
    Forum Contributor
    Join Date
    02-20-2009
    Location
    Manchester, England
    MS-Off Ver
    Excel 2007
    Posts
    467

    Conditional Formatting Copy & Paste

    If I add a confitional format to cell B3 which fills the cell an orange colour if B2 does not equal the same value. How do I copy and paste this format in to hundreds of rows below so that the conditional changes relatively, i.e. cell B4 fills orange if it does not equal cell B3 and so on...

    The condition also needs to not fill orange if that cell is blank.

    I know I will need to change the cell reference to not be absolute but I can not work out how to do this in excel 2007.

    Example attached if that helps.

    Thanks,
    Adam.
    Attached Files Attached Files
    Last edited by adam2308; 06-07-2010 at 06:03 PM.

  2. #2
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676

    Re: Conditional Formatting Copy & Paste

    Hello Adam,

    Often it's easiest to select the whole range first, e.g. select B3:B1000 (you can do that easily by typing B3:B1000 in the box above A1 and hitting ENTER)

    Then apply the formula that should apply to the top cell, i.e. use

    Conditional Formatting > New Rule > "use a formula to determine which cells to format" and then use this formula

    =AND(B3<>B2,B3<>"")

    Choose required format > OK

    That's it, all done
    Audere est facere

  3. #3
    Forum Contributor
    Join Date
    02-20-2009
    Location
    Manchester, England
    MS-Off Ver
    Excel 2007
    Posts
    467

    Re: Conditional Formatting Copy & Paste

    thanks daddylonglegs

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1