+ Reply to Thread
Results 1 to 4 of 4

Matching Values from different columns

  1. #1
    Forum Contributor
    Join Date
    08-20-2005
    Posts
    173

    Matching Values from different columns

    I have a column of 10 values in cells B1 TO B10 :
    (These change constantly and can be up to 25 values)

    Shell
    BP
    Castrol
    Jute
    Baldwin
    Mian
    BT
    Esso
    Costa
    Starbucks

    I am now going through values in Column C (1500 values):
    If a C value equals any of the B values in the list it will be shaded,
    I'm missing a little something in the code below, many thanks

    For i = 1500 to 1 Step -1
    If Cells(i,3) = ....
    Then cells(i,3).interior.colorindex = 33
    End If
    Next

  2. #2
    Forum Contributor stevebriz's Avatar
    Join Date
    09-07-2006
    Location
    Santiago Chile
    Posts
    389
    try this

    Please Login or Register  to view this content.
    VBA - The Power Behind the Grid

    Posting a sample of your workbook makes it easier to look at the Issue.

  3. #3
    Forum Contributor
    Join Date
    08-20-2005
    Posts
    173
    Thanks Steve, very helpful

  4. #4
    Forum Contributor
    Join Date
    03-15-2005
    Location
    North Carolina
    MS-Off Ver
    2003 & 2007
    Posts
    180
    You could eliminate VBA and use conditional formatting with

    =MATCH($B1,$C:$C,0)>0
    jtp

+ 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