+ Reply to Thread
Results 1 to 5 of 5

Are there any macros or ways to highlight all the lines enclosed by two types of symbols?

  1. #1
    Registered User
    Join Date
    12-19-2014
    Location
    Hong Kong
    MS-Off Ver
    Microsoft Excel 2013
    Posts
    6

    Are there any macros or ways to highlight all the lines enclosed by two types of symbols?

    Hello everyone.

    I want to find a macro or a way to highlight all lines enclosed by two types of symbols.

    For example,

    the document:
    Line 1
    !!!
    Line 3
    Line 4
    Line 5
    Line 6
    Line 7
    Line 8
    Line 9
    !!!
    Line 11
    Line 12
    Line 13
    Line 14

    After executing the macro or do the steps:
    Line 1
    !!!
    Line 3(Line To be Highlighted)
    Line 4(Line To be Highlighted)
    Line 5(Line To be Highlighted)
    Line 6(Line To be Highlighted)
    Line 7(Line To be Highlighted)
    Line 8(Line To be Highlighted)
    Line 9(Line To be Highlighted)
    !!!
    Line 11
    Line 12
    Line 13
    Line 14

    Thank you very much.

    I want to solve this problem for a long period of time!

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,445

    Re: Are there any macros or ways to highlight all the lines enclosed by two types of symbo

    Hi,

    This code should get you started

    Please Login or Register  to view this content.
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  3. #3
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: Are there any macros or ways to highlight all the lines enclosed by two types of symbo

    Suppose you want to highlight cells in the range A1:A100
    Then use this formula in conditional formatting
    =AND(COUNTIF($A$1:A1,"!!!")=1,COUNTIF(A1:$A$100,"!!!")=1)
    Check attached
    Attached Files Attached Files
    Happy to Help

    How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html

    "I don't get things easily, so please be precise and elaborate"

    If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
    If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.

    Sourabh

  4. #4
    Registered User
    Join Date
    12-19-2014
    Location
    Hong Kong
    MS-Off Ver
    Microsoft Excel 2013
    Posts
    6

    Re: Are there any macros or ways to highlight all the lines enclosed by two types of symbo

    Sorry I forget to mention that I want to do it in Microsoft Word instead of Microsoft Excel

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

    Re: Are there any macros or ways to highlight all the lines enclosed by two types of symbo

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    Ben Van Johnson

+ 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. Help me write a word macro to highlight all the areas enclosed by two types of symbols.
    By studyboymark in forum Word Programming / VBA / Macros
    Replies: 1
    Last Post: 12-21-2014, 05:20 PM
  2. Replies: 1
    Last Post: 12-19-2014, 04:23 PM
  3. [SOLVED] To copy expressions enclosed between < > symbols
    By rpa25 in forum Excel General
    Replies: 8
    Last Post: 08-05-2012, 12:01 PM
  4. Ways to Learn Macros
    By sighlent1 in forum Excel General
    Replies: 2
    Last Post: 01-08-2010, 05:24 PM
  5. [SOLVED] what other ways to get a picture or diagram of types of bacteria
    By SARS in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-27-2006, 02:10 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