+ Reply to Thread
Results 1 to 2 of 2

Change the color of all underscores and periods

  1. #1
    Registered User
    Join Date
    02-06-2019
    Location
    USA, CA
    MS-Off Ver
    office 365
    Posts
    4

    Change the color of all underscores and periods

    Hi. I'm god awful with Macros so I was hoping someone could either write this or give me some guidance on how to write this.

    Goals:
    1) Search through everything from column D
    2) Identify any _'s or .'s used
    3) Change the color of them to green without changing the text in any other area
    4) Do this automatically with each entry

    Let me know if you need any additional information! Thank you.

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,743

    Re: Change the color of all underscores and periods

    I don't have any details, so write it down without any data and test:

    Please Login or Register  to view this content.
    If you want check automaticaly each entry you can run this macro on Worksheet_Change (it pointless a bit checking whole col but as I said there is no details).
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

+ 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. Remove Underscores
    By Deantwi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-23-2016, 07:59 AM
  2. [SOLVED] VBA Remove All Spaces and Underscores
    By hobbiton73 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-14-2013, 01:32 PM
  3. [SOLVED] get rid of multiple underscores
    By lurchybold in forum Excel General
    Replies: 2
    Last Post: 10-06-2012, 04:36 AM
  4. Replies: 3
    Last Post: 07-08-2010, 06:48 PM
  5. eliminate spaces and turn periods into underscores
    By Luminary Xion in forum Excel General
    Replies: 5
    Last Post: 03-11-2008, 12:06 AM
  6. Format cell color on change, how to change the color in other columns as well?
    By s80NL in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-28-2007, 09:24 PM
  7. change loan periods in an amortization schedule
    By Barbara in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-01-2006, 02:40 PM
  8. [SOLVED] Calc % change by periods
    By Nick G. in forum Excel General
    Replies: 0
    Last Post: 01-17-2006, 12: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