Results 1 to 10 of 10

search & highlight the case sensitive text in one column that match a list on other column

Threaded View

  1. #1
    Registered User
    Join Date
    05-29-2020
    Location
    Chisinau
    MS-Off Ver
    2019
    Posts
    39

    Cool search & highlight the case sensitive text in one column that match a list on other column

    Hi guys... Can I get a VBA code that searches and highlights the case sensitive text in one column that matches short list (50 words) of the correct written text found on other column?

    I have more than 4000 names of whatever in the column that need to search inside the correct written words. They are duplicates, most of them, but that is not the problem. They should have been written in a specific way (I have a list of them), but someone manually wrote them differently. The filter cannot make the distinction between "MIKE" and "Mike" or "miKe", however VBA is case sensitive, so must be a solution.

    Can be solved without the need to invent and upload a sample file? Must be easy to understand what I ask. Thank you!
    Last edited by Alexander2020; 09-05-2020 at 01:11 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Case sensitive conditional formatting single column
    By MikeTi in forum Excel General
    Replies: 4
    Last Post: 05-11-2020, 01:49 PM
  2. [SOLVED] Search filter and highlight string - non case sensitive
    By Steve@Rugby in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-03-2017, 11:43 AM
  3. [SOLVED] Search Row by Column value and Highlight Text - For each Row
    By Discloner in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-08-2014, 01:52 PM
  4. Highlight duplicate rows based on column A but be case sensitive
    By theblade24 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-18-2013, 06:14 PM
  5. [SOLVED] Find word(s) within text string that matches a list of keywords - NOT case sensitive
    By gbm222 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2013, 02:15 AM
  6. [SOLVED] Macro for Case Sensitive Text Search
    By vcs1161 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-23-2013, 11:13 AM
  7. Replies: 2
    Last Post: 05-27-2012, 09:43 AM

Tags for this Thread

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