Results 1 to 8 of 8

Search Column for Criteria, Highlight Them Red

Threaded View

  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.

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