+ Reply to Thread
Results 1 to 8 of 8

Search Column for Criteria, Highlight Them Red

  1. #1
    Registered User
    Join Date
    07-26-2019
    Location
    NY
    MS-Off Ver
    1906, latest
    Posts
    26

    Search Column for Criteria, Highlight Them Red

    Hi excelhelpforum team,
    Thanks for your help in the past, I have posted a lot.

    We are in Google Sheets (attached), but this can be in Excel, too.

    Goal: search Job Title column for any of 60 terms. Once the term is found, we want to highlight the entire row red. It would be great if a macro can run a check on a list, and highlight everything in Column B which matches that list.

    Let's say the "red list" is Associate Investment Director and Managing Director for column B.

    Thanks again,
    AS
    Last edited by alansidman; 10-19-2021 at 05:24 PM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,484

    Re: Search Column for Criteria, Highlight Them Red

    @meowmeow22
    I have removed the attachment as it appeared to have data of a personal nature. The names, telephone numbers and emails appeared to be real and not dummy values. To protect those individuals privacy, I have removed the attachment. Please upload an attachment that contains dummy info that is representative of your actual data. You may wish to look at this link which will prepare that data for you. https://www.mockaroo.com/

    Alan
    Alan


    Have you debugged your code?
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    07-26-2019
    Location
    NY
    MS-Off Ver
    1906, latest
    Posts
    26

    (UPDATED) Re: Search Column for Criteria, Highlight Them Red

    Hi Alan,
    Thanks, I overlooked that and good point on anonymizing the data.

    Updated, please see attached.
    Attached Files Attached Files

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,484

    Re: Search Column for Criteria, Highlight Them Red

    Put your positions to look up in column Q

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    07-26-2019
    Location
    NY
    MS-Off Ver
    1906, latest
    Posts
    26

    Re: Search Column for Criteria, Highlight Them Red

    Hi Alan
    I remember posting yesterday but do not see it here.

    Is it possible to add Wildcards to the list in Column Q? It works very well.

    President, Director of Investment Management
    Chief Investment Officer
    Global Equity Investments
    Founder and Chief Executive Officer

    It would be great if I can do the following:

    **Director**
    **Investment**
    Global Equity Investments
    **Chief Executive Officer**

  6. #6
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,484

    Re: Search Column for Criteria, Highlight Them Red

    Yes we can, however, we need to use the LIKE function and not the EQUAL function.

    Please Login or Register  to view this content.
    Add your items to column Q, but do not include the wildcards as that is part of the VBA code

  7. #7
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    11,138

    Re: Search Column for Criteria, Highlight Them Red

    Here's a non looping option making use of helper column "N"...
    As per alan...
    Add your items to column Q, but do not include the wildcards as that is part of the VBA code
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by sintek; 10-23-2021 at 04:19 AM.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  8. #8
    Registered User
    Join Date
    07-26-2019
    Location
    NY
    MS-Off Ver
    1906, latest
    Posts
    26

    Re: Search Column for Criteria, Highlight Them Red

    Thanks all, will check and rep

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Search GSheets for Criteria, Highlight Them Red
    By meowmeow22 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 10-23-2021, 06:09 PM
  2. [SOLVED] search & highlight the case sensitive text in one column that match a list on other column
    By Alexander2020 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-07-2020, 03:17 AM
  3. [SOLVED] VBA to search for set day and highlight column
    By Crawfy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-20-2018, 02:59 AM
  4. [SOLVED] Search for empty cell in a row, highlight a range in that column
    By MDW12 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-02-2016, 10:01 AM
  5. [SOLVED] VB Script search within a column in one Wb and find in another WB and Highlight yellow
    By DixieDiver in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 10-23-2014, 02:57 PM
  6. [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
  7. Search and highlight hits only in Column C
    By kenelder in forum Excel General
    Replies: 5
    Last Post: 06-12-2013, 11:44 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