+ Reply to Thread
Results 1 to 8 of 8

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

  1. 09-08-2016, 08:39 AM #1
    faizzsheikh
    faizzsheikh is offline
    Registered User
    Join Date
    09-23-2012
    Location
    Mumbai
    MS-Off Ver
    Excel 2010
    Posts
    61

    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.
    Reply With QuoteRegister To Reply
  2. 09-08-2016, 09:09 AM #2
    cytop
    cytop is offline
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

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

    Also posted on OzGrid
    Reply With QuoteRegister To Reply
  3. 09-08-2016, 09:28 AM #3
    Alf
    Alf is online now
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,758

    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
    Reply With QuoteRegister To Reply
  4. 09-08-2016, 09:35 AM #4
    Alf
    Alf is online now
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,758

    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!!!
    Reply With QuoteRegister To Reply
  5. 09-08-2016, 09:55 AM #5
    cytop
    cytop is offline
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

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

    No problem Alf - I don't 'collect' rep points.
    Reply With QuoteRegister To Reply
  6. 09-08-2016, 11:14 AM #6
    Alf
    Alf is online now
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,758

    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
    Reply With QuoteRegister To Reply
  7. 09-08-2016, 12:28 PM #7
    faizzsheikh
    faizzsheikh is offline
    Registered User
    Join Date
    09-23-2012
    Location
    Mumbai
    MS-Off Ver
    Excel 2010
    Posts
    61

    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.
    Reply With QuoteRegister To Reply
  8. 09-08-2016, 01:53 PM #8
    Alf
    Alf is online now
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,758

    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 With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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. Automatically change the text to multi color in the cell when use a specific text
    By Underworld in forum Excel General
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1