1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

[VBA] Auto-color common word patterns upon selection

Discussion in 'VBA Macros' started by smallxyz, Feb 7, 2018.

  1. smallxyz

    smallxyz New Member

    Messages:
    23
    Hi,

    I have the following words written into cells A1,A2, … A9

    e.g.

    appletree
    applestore
    appleiphone
    tweetbird
    angrybird
    funnybird
    bigredhat
    smallrednose
    hugeredpocket


    Upon selecting these cells and applying the VBA script, I would like to highlight common patterns among consecutive cells, as follows:

    appletree
    applestore
    appleiphone
    tweetbird
    angrybird
    funnybird
    bigredhat
    smallrednose
    hugeredpocket


    Anyone get some ideas to achieve this?
    Thanks a lot!
  2. Marc L

    Marc L Excel Ninja

    Messages:
    3,685
    Hi !

    In this case, manually …

    Easier by code with real words, with a space between them …
  3. smallxyz

    smallxyz New Member

    Messages:
    23
  4. Marc L

    Marc L Excel Ninja

    Messages:
    3,685

    « how? » What ?

    Can do nothing with your sample as it is …​
  5. smallxyz

    smallxyz New Member

    Messages:
    23
    Let 's wait for other response.
  6. Marc L

    Marc L Excel Ninja

    Messages:
    3,685
    Let's wait for your analyse of your need :
    what is your strategy, the logic to apply ? …

    Once you have it - a valid one - don't forget Macro Recorder
    and operate manually : you will get your own free code base …

Share This Page