Results 1 to 8 of 8

match names of B column with column C and then highlight

Threaded View

keshavtale match names of B column with... 09-06-2019, 07:42 AM
KOKOSEK Re: match names of B column... 09-06-2019, 08:04 AM
keshavtale Re: match names of B column... 09-06-2019, 08:26 AM
KOKOSEK Re: match names of B column... 09-06-2019, 08:58 AM
keshavtale Re: match names of B column... 09-06-2019, 09:20 AM
KOKOSEK Re: match names of B column... 09-06-2019, 09:39 AM
keshavtale Re: match names of B column... 09-06-2019, 10:26 AM
KOKOSEK Re: match names of B column... 09-06-2019, 10:35 AM
  1. #1
    Forum Contributor keshavtale's Avatar
    Join Date
    03-13-2013
    Location
    india
    MS-Off Ver
    excel 2019
    Posts
    620

    match names of B column with column C and then highlight

    Look in to the attached file in column B first name vansh corporation first four letter that name is vansh match that letters
    with name in the C column then it would be found correct matching with name which is in cell C8 then highlight that both name
    in colour yellow then again same letters is in cell B12 again match that first four letter in name of column of C but this time
    it would not found so become it in red colour , and so on, do this process with every name of column B and compare with it to column C,
    please give me VBA code for that
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Highlight Approximate Match in a column (Not exact Match)
    By rahuleyes in forum Excel General
    Replies: 1
    Last Post: 09-07-2019, 08:47 AM
  2. [SOLVED] Highlight Invoices column B match column A
    By majidsiddique in forum Excel General
    Replies: 9
    Last Post: 01-18-2019, 10:06 AM
  3. [SOLVED] Match the column and highlight the difference
    By buvanamali in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-25-2018, 10:22 AM
  4. Replies: 2
    Last Post: 12-08-2015, 03:01 PM
  5. Match Column Names based on Primary Key in Column A
    By KG23 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-17-2014, 04:24 PM
  6. Match names in column with duplicates
    By keis386 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-28-2014, 12:03 PM
  7. Match names in two separate column if = then pull info in 3 column
    By Bevg in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-07-2013, 08:31 PM

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