+ Reply to Thread
Results 1 to 2 of 2

Modify Macro Search & Replace Formatting for part of cell

  1. #1
    Registered User
    Join Date
    03-02-2011
    Location
    Denver, CO
    MS-Off Ver
    Excel 2007
    Posts
    1

    Modify Macro Search & Replace Formatting for part of cell

    Hello,
    The macro below searches for the text "textiles" in a cell. If it finds it, it makes that word, and only that word, Bold within the cell. I'd like it also to change the color to red so that it is Bold and Red. I think I need to add Font.Color = Red somewhere. Can someone show me where to put it so that it changes the keyword to Bold and Red?
    Thanks,
    T

    Please Login or Register  to view this content.
    Last edited by tkeiffer; 03-02-2011 at 05:53 PM. Reason: Did not follow rules for posting code

  2. #2
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Modify Macro Search & Replace Formatting for part of cell

    hi, tkeiffer, please amend your post to follow Forum rules when posting VB code

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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