+ Reply to Thread
Results 1 to 2 of 2

Compare cells/columns and highlight matching text strings

  1. #1
    luxbelle
    Guest

    Compare cells/columns and highlight matching text strings


    Hello guys,

    As the thread title reads, I need to compare text strings between two
    cells/columns, and highlight those that match between them.

    Example:
    --------------------------------
    A1:
    VW, GM, CHRYSLER, VOLVO, FORD

    B1:
    FORD, GM, MITSUBISHI, NISSAN
    --------------------------------

    The idea is that FORD and GM be highlighted in A1, since the
    conditional formatting would find those text strings in B1. Note that
    the strings in A1 and B1 will always be different, varying by row.


    Thanks for reading and hope you can help me with this!


    --
    luxbelle

  2. #2
    nbrcrunch
    Guest

    Re: Compare cells/columns and highlight matching text strings


    You need to have each element (car name) in its own cell. You cannot use
    conditional format to selectively highlight a portion of a cell.

    The FIND() function can be used to write a formula that will put a
    value in an adjoining cell if criteria is found for both, but not
    conditional formatting.

    For example, if cell A1 contains:
    Ford, Chevy, Mazda

    and cell B1 contains:
    Chevy, Mercedes, Accord

    You could have column C be your column for finding your matches of
    Chevy, column D your column for finding matches of Ford, etc.

    C1 formula could be:
    =IF(AND(FIND("Chevy",A1,1),FIND("Chevy",B1,1)),"Match","")


    --
    nbrcrunch

+ 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