Closed Thread
Results 1 to 8 of 8

Find Text in cell and bold that line

  1. #1
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    516

    Find Text in cell and bold that line

    Hello everyone,

    I have a cell with several lines, i would like to search for "1º", and when find bold that whole line.
    I found a macro that finds a text and bold it: (But has a lot of uncessary stuff i don't need like input box and stuff., only need to find 1º and bold line )

    Code:
    Please Login or Register  to view this content.
    My Cell A1 must be like this:
    3º ABC
    2º ABB
    1º ACCC
    5º ASDASD
    5º ASDAS
    6º ASDA

    Essential what i need to when i find 1º bold that line.

    Thanks for all your help

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: Find Text in cell and bold that line

    Hi brainzlp

    Here's one way...
    Assumes Column A with a Header...
    Please Login or Register  to view this content.
    Last edited by sintek; 07-14-2018 at 03:56 PM.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: Find Text in cell and bold that line

    Please Login or Register  to view this content.
    Ben Van Johnson

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Find Text in cell and bold that line

    Rule 08: Cross-posting Without Telling Us

    Your post does not comply with Rule 8 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

    Post a link to any other forums where you have asked the same question. If you have fewer than 10 posts here, you will not be able to post a link, but you must still tell us where else you have asked the question.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

    Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

    If you have less than 10 posts, do not try to copy and paste the link. Instead, type the link out in your thread.

    No further help to be offered, please, until the OP has complied with this request.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  5. #5
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    516

    Re: Find Text in cell and bold that line

    Once problem is solved i close in the other fórum. I have this postes on mr Excel and here. But there no one can give me answer to solve this.

  6. #6
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    516

    Re: Find Text in cell and bold that line

    Quote Originally Posted by sintek View Post
    Hi brainzlp

    Here's one way...
    Assumes Column A with a Header...
    Please Login or Register  to view this content.
    I dont want to bold a row. But a line inside a cell. I gave A1 as an example, the efectiva cell is V91 although changes along time and its associated as variable. Thanks anyway

  7. #7
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    516

    Re: Find Text in cell and bold that line

    Quote Originally Posted by protonLeah View Post
    Please Login or Register  to view this content.
    Hello,

    Your code seems to do the job, i will test tomorrow once i Get to the computer at work (i am in the Phone now)

    I Will let you know tomorrow. Thanks in advance for your time

  8. #8
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Find Text in cell and bold that line

    You have not supplied a link to the other link. Since you are not adhering to forum rules and you are ignoring my moderation requests, I have no choice but to close this thread.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 08-02-2016, 01:58 AM
  2. Find, Select and Copy Bold Text/Cell (from the top)
    By epoiezam in forum Excel General
    Replies: 1
    Last Post: 02-10-2016, 10:53 PM
  3. Insert Bold Line After Counting Cell Values
    By temple.georgia in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-14-2012, 05:43 AM
  4. Control Adobe via Excel - Find line type (i.e. bold vs dash)
    By Kavy1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-08-2012, 10:46 AM
  5. Find and highlight/bold/underline/colour a block of matching text (is this possible?)
    By joelhuang in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 08-02-2011, 07:44 AM
  6. Split cell - bold text and non bold text.
    By desertshift in forum Excel General
    Replies: 10
    Last Post: 11-21-2010, 08:13 PM
  7. Join bold and non-bold text in one cell
    By bkincaid in forum Excel General
    Replies: 3
    Last Post: 03-20-2006, 09:10 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