+ Reply to Thread
Results 1 to 4 of 4

if cell contains one of several values in Excel

  1. #1
    Registered User
    Join Date
    10-08-2023
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    35

    if cell contains one of several values in Excel

    Hello brother,

    please support me in the Excel with vba Function

    you will find Inside excel two sheets the first sheet is called Name Domain, in sheet Domain includes two columns Url and Description, and the second sheet is called Target keywords

    What I need is below
    I will put my target keyword list in column A in Target keywords containing three words, not 1 word, I want to change the cell color in the description in the domain sheet for each cell if it contains one of several values based on Target Keywords
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    10-08-2023
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    35

    Re: if cell contains one of several values in Excel

    i will explain to you why.

    I extract links from Google Search and Bing and then extract meta tag descriptions of these links and then I will filter them by my target keywords in the description in order to extract my target company website easily for example if the description includes these keywords the cell change color and this my target domain

    mean convert URL to the category but via target keyword

    I hope you can understand me brother

  3. #3
    Registered User
    Join Date
    10-08-2023
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    35

    Re: if cell contains one of several values in Excel

    sorry attached file xls
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,206

    Re: if cell contains one of several values in Excel

    Last edited by JohnTopley; 10-12-2023 at 04:02 PM.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ 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. Excel VB Script to Fill Values Based on Common Values in an Adjacent Cell
    By oarsout in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-02-2021, 12:36 PM
  2. Replies: 9
    Last Post: 09-07-2016, 11:39 AM
  3. Replies: 8
    Last Post: 05-01-2015, 02:07 PM
  4. sum cell values by criteria there cell color (Excel Mac 2011)
    By Opi12 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 02-25-2015, 07:58 AM
  5. Replies: 3
    Last Post: 09-08-2014, 04:29 PM
  6. Replies: 2
    Last Post: 10-21-2010, 04:41 AM
  7. Change cell values based on Active Cell Address in Excel 2007 with no VBA
    By bdmistri in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-07-2009, 02:01 PM

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