+ Reply to Thread
Results 1 to 8 of 8

How to find replace or change specific text color in a range

  1. #1
    Registered User
    Join Date
    09-23-2012
    Location
    Mumbai
    MS-Off Ver
    Excel 2007
    Posts
    54

    How to find replace or change specific text color in a range

    Hi.. Below is what I want to do, I have a large set of similar data.


    Before (The text color of "Doctors" is simple):

    Column A
    best-doctors-for-teeth-whitening
    find-treatment-for-wisdom-tooth-removal
    best-doctors-for-dental-screening-and-prophylaxis
    best-doctors-for-smile makeover-smile design
    best-doctors-for-braces
    specialist-for-dental-ceramics
    find-treatment-for-teeth-straighting
    find-treatment-for-dental-check-ups-and-cleaning
    best-doctors-for-root-canal-treatment
    find-treatment-for-mouth-guards

    ----

    After (The text color of only "Doctors" should be RED):

    Column A
    best-doctors-for-teeth-whitening
    find-treatment-for-wisdom-tooth-removal
    best-doctors-for-dental-screening-and-prophylaxis
    best-doctors-for-smile makeover-smile design
    best-doctors-for-braces
    specialist-for-dental-ceramics
    find-treatment-for-teeth-straighting
    find-treatment-for-dental-check-ups-and-cleaning
    best-doctors-for-root-canal-treatment
    find-treatment-for-mouth-guards


    I tried Find Replace > Options > Format but it changes all the text color into red


    This question is also posted on Ozgrid
    Last edited by faizzsheikh; 09-08-2016 at 12:27 PM.

  2. #2
    Forum Expert (Lazarus)
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    .
    Posts
    2,594

    Re: How to find replace or change specific text color in a range

    Also posted on OzGrid

  3. #3
    Forum Expert
    Join Date
    03-13-2004
    Location
    Gothenburg/Stockholm, Sweden
    MS-Off Ver
    Excel 2003, Excel 2007 & reluctant Excel 2010 user
    Posts
    4,484

    Re: How to find replace or change specific text color in a range

    Also posted on OzGrid
    That is a big no no! Will wait posting my answer untill he has modefied his post with a link to the OzGrid forum.

    Alf

  4. #4
    Forum Expert
    Join Date
    03-13-2004
    Location
    Gothenburg/Stockholm, Sweden
    MS-Off Ver
    Excel 2003, Excel 2007 & reluctant Excel 2010 user
    Posts
    4,484

    Re: How to find replace or change specific text color in a range

    Also posted on OzGrid
    That is a big no no! Will wait posting my answer untill he has modefied his post with a link to the OzGrid forum.

    Alf

    Ps Cytop urgent!!! I got a strange message when I tried to give you rep for spotting the doubble posting. Did I instead remove reps from you. If so my bad. Will PM a moderator and ask them to check asap!!!

  5. #5
    Forum Expert (Lazarus)
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    .
    Posts
    2,594

    Re: How to find replace or change specific text color in a range

    No problem Alf - I don't 'collect' rep points.

  6. #6
    Forum Expert
    Join Date
    03-13-2004
    Location
    Gothenburg/Stockholm, Sweden
    MS-Off Ver
    Excel 2003, Excel 2007 & reluctant Excel 2010 user
    Posts
    4,484

    Re: How to find replace or change specific text color in a range

    No problem Alf - I don't 'collect' rep points.
    But did you get a neg rep? I've informed a moderator FDibbins with a link to this thread and asked him to check and correct if necceary.

    So even if you don't "collect" rep points if I made a mistake I do wish to get things fixed.

    Alf

  7. #7
    Registered User
    Join Date
    09-23-2012
    Location
    Mumbai
    MS-Off Ver
    Excel 2007
    Posts
    54

    Re: How to find replace or change specific text color in a range

    Sorry about that Alf. Just updated my post with the link to the Ozgrid post.

  8. #8
    Forum Expert
    Join Date
    03-13-2004
    Location
    Gothenburg/Stockholm, Sweden
    MS-Off Ver
    Excel 2003, Excel 2007 & reluctant Excel 2010 user
    Posts
    4,484

    Re: How to find replace or change specific text color in a range

    Ok here we go. See if this macro does what you wish for.

    Please Login or Register  to view this content.
    Alf

+ 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. Find and Replace Text Color
    By galetondesigns in forum Excel General
    Replies: 7
    Last Post: 12-16-2015, 01:46 AM
  2. [SOLVED] Search through columns and find specific text and replace that text with header column
    By adamzee in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-09-2014, 11:59 PM
  3. vba Find specific text font and change color
    By jacgeld in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-18-2014, 08:16 AM
  4. Replies: 0
    Last Post: 03-12-2013, 04:29 PM
  5. [SOLVED] Change the color of a row in a specific range
    By arkadd61 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-17-2013, 07:00 PM
  6. how to find a color in a row where the color is blue , if true fill with a specific text
    By jayakumar.chandran in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-01-2012, 03:38 AM
  7. [SOLVED] Change text color of specific date range by macro in Excel
    By Morgan LeFay in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-03-2006, 02:55 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