Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

Results 1 to 3 of 3

Thread: Match Cells In One Column To Cells In Another

  1. #1
    Join Date
    10th September 2007

    Match Cells In One Column To Cells In Another


    I want to try and create a macro that will start with the value in the first cell of one column and find it another column and highlight both itself and the other value and then move onto the next value in the cell below and repeat the same process until it reaches the end of the column.

    This would result in leaving unhighlighted cells as new items as it were that did not exist before.

    If anyone can help or give me a few pointers, I would be very grateful.



    Excel Video Tutorials / Excel Dashboards Reports

  2. #2
    Join Date
    25th May 2004
    central Europe

    Re: Match Cells In One Column To Cells In Another

    I suggest conditional formatting in this case.
    In formulae, depending on your locale, you might have to replace ; with , or vice versa.

  3. #3
    Join Date
    5th May 2006
    Texas, USA

    Re: Match Cells In One Column To Cells In Another

    Here is a walk through of a possible conditional formatting solution:

    Select the entire column you are wanting to check. For this example I am using column D
    Go to Format>>>Conditional Formatting
    Change the drop down box from "Cell Value Is" to "Formula Is" and use this formula =COUNTIF($A$1:$Z$100,D1)>1
    Adjust $A$1:$Z$100 to meet your range. Change D1 to your column.
    Pick a background color you want and this will highlight any cell in your chosen column that appears more than one time in your table.

    This does not highlight the matching cells in the other columns.


    Excel Video Tutorials / Excel Dashboards Reports

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Replies: 5
    Last Post: July 1st, 2008, 14:00
  2. Replies: 2
    Last Post: May 20th, 2008, 14:13
  3. Copy Rows Where Cells In Column Match Condition/Criteria
    By Meissy Freeman in forum Excel General
    Replies: 9
    Last Post: May 8th, 2008, 03:14
  4. Replies: 4
    Last Post: October 11th, 2006, 17:28
  5. [Solved] Formulas: adding cells if other cells match...
    By Exceladdict in forum Excel General
    Replies: 5
    Last Post: November 14th, 2003, 12:44


Posting Permissions

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