+ Reply to Thread
Results 1 to 4 of 4

To Highlight all the occurences of a specific word in a single cell.

  1. #1
    Forum Contributor
    Join Date
    02-13-2016
    Location
    MUMBAI
    MS-Off Ver
    Microsoft 365
    Posts
    180

    To Highlight all the occurences of a specific word in a single cell.

    Hello All,

    I have suppose 10 lines written in a single cell in a excel sheet & in that cell the word "Colour" is repeated 8 times. I want to highlight all the occurrences of the word "colour" in the cell rather than highlighting the entire cell.

    Please Help..

  2. #2
    Registered User
    Join Date
    06-06-2017
    Location
    Wimborne, England
    MS-Off Ver
    Office 365 Business
    Posts
    30

    Re: To Highlight all the occurences of a specific word in a single cell.

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    02-13-2016
    Location
    MUMBAI
    MS-Off Ver
    Microsoft 365
    Posts
    180

    Re: To Highlight all the occurences of a specific word in a single cell.

    Hi MrChipper,

    I didn't got your code..how it works.. i have run the code & nothing happened??

    Let me give u an example..

    Suppose this is my paragraph written in a cell:

    Apple is nutritious. Apple is good for health. An apple a day keeps the doctor away. Do eat an apple daily.

    Now in this i want to highlight all the occurences of the word Apple..how i do it with that code?

  4. #4
    Registered User
    Join Date
    06-06-2017
    Location
    Wimborne, England
    MS-Off Ver
    Office 365 Business
    Posts
    30

    Re: To Highlight all the occurences of a specific word in a single cell.

    Hi Vivek2705,

    This code will do precisely what you have requested, i.e highlight occurences of the word "Apple" by changing the font to red (on my version of excel). I don't think its a total solution, as its case sensitive and will only work for that specific word, but perhaps points you in the direction of a more comprehensive solution...

    Please Login or Register  to view this content.

+ 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] Count words in a cell & output number of occurences of each word in adjecent cell.
    By kprasad in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-16-2017, 07:28 AM
  2. Replies: 2
    Last Post: 01-16-2014, 07:25 PM
  3. Replies: 14
    Last Post: 10-11-2013, 12:09 AM
  4. Replies: 1
    Last Post: 06-04-2013, 03:26 PM
  5. [SOLVED] Highlight a range of cells if a single cell contains specific text
    By ZHertz in forum Excel General
    Replies: 3
    Last Post: 10-19-2012, 02:54 PM
  6. Replies: 6
    Last Post: 11-11-2009, 09:00 AM
  7. Counting specific word occurences in a cell
    By KenRamoska in forum Excel General
    Replies: 3
    Last Post: 08-03-2006, 01:50 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