+ Reply to Thread
Results 1 to 3 of 3

Find a word/s in a sentence, in a cell, in entire column, mark bold and in red for each

  1. #1
    Registered User
    Join Date
    10-24-2013
    Location
    Southern CA
    MS-Off Ver
    Excel 2007
    Posts
    25

    Find a word/s in a sentence, in a cell, in entire column, mark bold and in red for each

    2 things...

    1. I need to: find a word/s within a sentence within a cell within a column if they are there. If they are not there, do nothing.... The search will need to cover the entire column searching through every entry in that column and and it's not column A but another column like column D. The sentences may or may not be the same.

    ---- Example Sentence1: The quick brown fox jumped over the lazy dog.
    ---- Example Sentance2: The lazy cat is upstairs on the bed.
    ---- Example Sentance3: Fourteen bags of wheat are needed and I don't know why.
    ---- The words to FIND are = fox quick dog lazy

    Now, once it finds 1 or more of the words in each sentence, CAN those words only be BOLDED AND COLOR CHANGED TO RED

    RESULT: The quick brown fox jumped over the lazy dog.


    2. And Plan B, is to make the entire sentence bold and color/fill the entire cell yellow.

  2. #2
    Registered User
    Join Date
    10-24-2013
    Location
    Southern CA
    MS-Off Ver
    Excel 2007
    Posts
    25

    Re: Find a word/s in a sentence, in a cell, in entire column, mark bold and in red for eac

    EXAMPLE FOR EXCEL HELP pic.JPG

    pic shows the basics of what I'm looking for

  3. #3
    Registered User
    Join Date
    10-24-2013
    Location
    Southern CA
    MS-Off Ver
    Excel 2007
    Posts
    25

    Re: Find a word/s in a sentence, in a cell, in entire column, mark bold and in red for eac

    any help is hugely appreciated guys.

+ 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. Need to find a word in a cell, copy the entire cell and two adjacent columns on same row
    By hang_sandwich in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-01-2012, 11:16 AM
  2. Find word in sentence
    By WCE_123 in forum Excel General
    Replies: 2
    Last Post: 09-21-2011, 06:59 AM
  3. How to find and replace a word in a sentence with VBA
    By Gunilla in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-20-2010, 09:52 PM
  4. Replies: 5
    Last Post: 07-11-2008, 02:47 PM
  5. bold entire row when value in column changed
    By ayl322 in forum Excel General
    Replies: 2
    Last Post: 05-04-2005, 12:54 PM

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