+ Reply to Thread
Results 1 to 4 of 4

Text match

  1. #1
    Forum Contributor
    Join Date
    04-23-2007
    Location
    Texas
    Posts
    417

    Text match

    I have a workbook where in column A10 down has text. If the same text is found anywhere else in column A - Turn interior color grey from A-I on that row and lock those grey cells.

    So if a user is filling in the workbook, in column A10 would be Dog23 and then in column A11 the user adds Dog23 B11-I11 turn grey and lock for editing. This would be turn down the sheet. If Cat11 where added to A12, B12-I12 would be open for editing.

    I've tried to do an IF statement but can't get it to work properly.

    Thank you!
    Last edited by Tortus; 07-23-2015 at 08:34 AM.
    If we all use our Minds our Heads and our Brains NO TELLING what we could come up with!!

  2. #2
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2010
    Posts
    2,308

    Re: Text match

    It's kind of clunky, but it seems to work....You'll need to put this in the WorkSheet section of the VB Editor.

    Please Login or Register  to view this content.
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....

  3. #3
    Forum Contributor
    Join Date
    04-23-2007
    Location
    Texas
    Posts
    417

    Re: Text match

    This basically does what I need, thank you for your help!

  4. #4
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2010
    Posts
    2,308

    Re: Text match

    you're welcome....glad I could help and thanks for the rep points....have a great day

+ 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. [SOLVED] How to match a cell with text with a range of text and return own text
    By ec4excel in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-16-2014, 11:07 AM
  2. [SOLVED] Match week and populate approve/reject text after each match row
    By lumiance in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-10-2014, 08:00 AM
  3. [SOLVED] sumif which finds text, not an exact match, but a close match instead
    By Beefy1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-19-2014, 08:29 PM
  4. [SOLVED] Two Excel sheets trying to match text data and return the match from the second column!
    By bankcott in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-02-2013, 02:17 PM
  5. Replies: 13
    Last Post: 12-13-2012, 11:44 AM
  6. [SOLVED] Match text in 2 columns, if true output adjacent cell to the match.
    By kenoboy in forum Excel General
    Replies: 3
    Last Post: 07-03-2012, 09:52 AM
  7. [SOLVED] Lookup? Match? pulling rows from one spreadsheet to match a text f
    By cjax in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-21-2006, 09:51 AM

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