+ Reply to Thread
Results 1 to 27 of 27

Special Characters to be Highlighted

  1. #1
    Registered User
    Join Date
    07-22-2013
    Location
    Chennai,India
    MS-Off Ver
    Excel 2007, 2010, 2013
    Posts
    26

    Exclamation Special Characters to be Highlighted

    Hi... Currently am using a macro for highlighting cells containing special characters in "L" column. But i need a macro to highlight the cells in one color and the special character in another color in "L" column. This will help me in searching the special character in that cell. Also i need a pop for special character count.


    Current Macro as below:
    Please Login or Register  to view this content.
    Last edited by dhilipan; 07-24-2013 at 12:32 AM. Reason: Update

  2. #2
    Registered User
    Join Date
    03-27-2013
    Location
    Long Island, NY
    MS-Off Ver
    Excel 2007
    Posts
    35

    Re: Special Characters to be Highlighted

    Have you tried using :

    Please Login or Register  to view this content.
    Last edited by thelisa; 07-24-2013 at 09:25 AM.

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Special Characters to be Highlighted

    1) You both need to edit your post and wrap the code with the code tag by the rule.
    e.g
    [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code]

    2) try
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    07-22-2013
    Location
    Chennai,India
    MS-Off Ver
    Excel 2007, 2010, 2013
    Posts
    26

    Re: Special Characters to be Highlighted

    Hi jindon...
    1> I have edited my post.
    2> Your code works fine, but special characters are need to be replaced by my conditions. can you help in that. Also will be very helpful if we got the count for highlighted character.
    conditions are :
    (
    ,
    )
    \
    double space
    !
    @
    #
    $
    %
    ^
    &
    *
    home
    depot
    and,
    or,
    Space-Space
    space-
    -space
    Last edited by dhilipan; 07-24-2013 at 12:48 AM.
    Regards
    Dhilip

  5. #5
    Registered User
    Join Date
    07-22-2013
    Location
    Chennai,India
    MS-Off Ver
    Excel 2007, 2010, 2013
    Posts
    26

    Re: Special Characters to be Highlighted

    Hi.. Thanks for your reply.
    Can you tel me where i have to insert this code.

    Quote Originally Posted by thelisa View Post
    Have you tried using :

    With Selection.Font
    .Color = 'color here
    .TintAndShade = 0
    End With

  6. #6
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Special Characters to be Highlighted

    No idea what you are trying to do.

    Post a workbook with before/after format.

  7. #7
    Registered User
    Join Date
    07-22-2013
    Location
    Chennai,India
    MS-Off Ver
    Excel 2007, 2010, 2013
    Posts
    26

    Re: Special Characters to be Highlighted

    A.JPG
    I have uploaded a image for better reference.
    Cell below A is the result of my current macro. But i need a result as shown in the cell below B

    Quote Originally Posted by dhilipan View Post
    Hi.. Thanks for your reply.
    Can you tel me where i have to insert this code.

  8. #8
    Registered User
    Join Date
    07-22-2013
    Location
    Chennai,India
    MS-Off Ver
    Excel 2007, 2010, 2013
    Posts
    26

    Re: Special Characters to be Highlighted

    Quote Originally Posted by jindon View Post
    No idea what you are trying to do.

    Post a workbook with before/after format.
    A.JPG
    I have uploaded a image for better reference.
    Cell below A is the result of my current macro. But i need a result as shown in the cell below B

  9. #9
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Special Characters to be Highlighted

    Quote Originally Posted by jindon View Post
    Post a workbook with before/after format.
    Picture doesn't help at all.

  10. #10
    Registered User
    Join Date
    07-22-2013
    Location
    Chennai,India
    MS-Off Ver
    Excel 2007, 2010, 2013
    Posts
    26

    Arrow Re: Special Characters to be Highlighted

    Quote Originally Posted by jindon View Post
    Picture doesn't help at all.
    I have attached the sample excel file [Original is highly confidential]
    I need to verify a column contains special character or not. if found then the cell and the character should be highlighted.
    Attached Files Attached Files

  11. #11
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Special Characters to be Highlighted

    You didn't show AFTER.
    Please Login or Register  to view this content.

  12. #12
    Registered User
    Join Date
    07-22-2013
    Location
    Chennai,India
    MS-Off Ver
    Excel 2007, 2010, 2013
    Posts
    26

    Unhappy Re: Special Characters to be Highlighted

    [QUOTE=jindon;3336068]You didn't show AFTER.
    Hi Jindon, i dont know how to show you "AFTER" coz i dont have what i need.
    My requirement is

    Before----------After-------------------Remarks
    Find my place |Find my place |double space between the words my and place, that should be highlighted
    find -my place |find -my place |Space before "-" need to be highlighted
    find - my place |find - my place |Space before and after "-" need to be highlighted

  13. #13
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Special Characters to be Highlighted

    Quote Originally Posted by dhilipan View Post
    Hi Jindon, i dont know how to show you "AFTER" coz i dont have what i need.
    Huh???

    How would I know?


    This must be a joke.

  14. #14
    Registered User
    Join Date
    07-22-2013
    Location
    Chennai,India
    MS-Off Ver
    Excel 2007, 2010, 2013
    Posts
    26

    Re: Special Characters to be Highlighted

    Ok Jindon,
    Can you help me in this, need to highlight if the cells in column contains "and," "or,"
    Quote Originally Posted by jindon View Post
    Huh???

    How would I know?


    This must be a joke.

  15. #15
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Special Characters to be Highlighted

    Already done it in #11.

  16. #16
    Registered User
    Join Date
    07-22-2013
    Location
    Chennai,India
    MS-Off Ver
    Excel 2007, 2010, 2013
    Posts
    26

    Re: Special Characters to be Highlighted

    No Jindon, "and," Special character "," need to be add to that
    Quote Originally Posted by jindon View Post
    Already done it in #11.

  17. #17
    Registered User
    Join Date
    07-22-2013
    Location
    Chennai,India
    MS-Off Ver
    Excel 2007, 2010, 2013
    Posts
    26

    Question Need to highlight special character and the cells contains special character

    Hi i need to highlight special character and the cells contains special character. currently am using below macro, but its only highlighting cells and not the special character. Also i need the count of special character by a pop up message.
    Please Login or Register  to view this content.

  18. #18
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Need to highlight special character and the cells contains special character

    Hello dhilipan,

    This will color the special characters red and return the count in the message box.
    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  19. #19
    Registered User
    Join Date
    07-22-2013
    Location
    Chennai,India
    MS-Off Ver
    Excel 2007, 2010, 2013
    Posts
    26

    Re: Need to highlight special character and the cells contains special character

    Hi Leith, thanks. but this is not highlighting special characters :-( Also i need to do this in "L" column. I need check this for quality check in large data from others. please help
    Quote Originally Posted by Leith Ross View Post
    Hello dhilipan,

    This will color the special characters red and return the count in the message box.
    Please Login or Register  to view this content.

  20. #20
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Special Characters to be Highlighted

    I don't want to repeat this again.

    "Show me what you have and the result that you want."

  21. #21
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Need to highlight special character and the cells contains special character


  22. #22
    Registered User
    Join Date
    07-22-2013
    Location
    Chennai,India
    MS-Off Ver
    Excel 2007, 2010, 2013
    Posts
    26

    Unhappy Re: Special Characters to be Highlighted

    Hi Jindon, i have attached the file, i need result as i sheet 1 and added the characters to be highlighted in sheet 2.
    Quote Originally Posted by jindon View Post
    I don't want to repeat this again.

    "Show me what you have and the result that you want."
    Attached Files Attached Files

  23. #23
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Special Characters to be Highlighted

    Hello dhilipan,

    It seems that you are still learning VBA.

    I used the great Code which Leith Ross has provided you with, and simply changed the Column references, to work for you in Column L.

    In the attached Workbook, I have also provided you with various other ways of how to deal with Special Characters. Play around with it, see how it works, and use what you like.

    Also see the "Please consider" note at the bottom of this post.
    Attached Files Attached Files
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  24. #24
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Special Characters to be Highlighted

    Please Login or Register  to view this content.
    Attached Files Attached Files

  25. #25
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Special Characters to be Highlighted

    Hello dhilipan,

    You are welcome.

    Thank you for adding to my Reputation.

    Hope you find the examples usefull.

  26. #26
    Registered User
    Join Date
    01-25-2015
    Location
    jordan
    MS-Off Ver
    2010
    Posts
    7

    Re: Special Characters to be Highlighted

    hey can you give me a code to do that on a workbook i have please

  27. #27
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Special Characters to be Highlighted

    Hello dabbas555,

    We don't know what your workbook looks like, nor what your exact requirement is

    Please attach a sample workbook.

    Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

    Thank you.

+ 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. vba sql special characters
    By Jollyfrog in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-26-2014, 06:49 PM
  2. Macro to replace European characters with non "special" English characters?
    By johanna0507 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2012, 09:13 AM
  3. Special characters
    By dandi10 in forum Excel General
    Replies: 4
    Last Post: 04-11-2012, 01:21 PM
  4. Special characters
    By wag in forum Excel General
    Replies: 1
    Last Post: 09-08-2009, 03:25 PM
  5. special characters (little box)
    By YuChieh in forum Excel General
    Replies: 9
    Last Post: 06-14-2005, 09:05 AM

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