+ Reply to Thread
Results 1 to 7 of 7

Find and Replace

  1. #1
    Registered User
    Join Date
    08-16-2012
    Location
    Phoenix
    MS-Off Ver
    Excel 2010
    Posts
    58

    Find and Replace

    I have a Diary which has 5,000+ cells (20 years) so it would be nice if I could do a "Find and replace" However when I do this and I change the color and Fonts the entire cell. At least half of my diary is color coded so is there any way to just change one word thoughout my document to the font and color I want without the entire cell being change. Example: I might want to change the word "work" to "Work" and if I do that every word in the cell is change. I have Excel 2010.

  2. #2
    Forum Contributor
    Join Date
    08-04-2011
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2007
    Posts
    109

    Re: Find and Replace

    Unfortunately you can't have multiple text colors in a single cell. Have you thought about using adjacent columns to indicate the existence of key words. For example, column B could indicate "Work" and if your text contains the word "work" it would flag using a Y/N, or TRUE/FALSE. This way you could also sort by your keyword columns and review all instances that contain your keyword at the top of the list. This would also allow you to have a significant number of keyword columns without your original text looking like a rainbow. You could also hide your keyword columns when not needed.

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

    Re: Find and Replace

    Try
    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    08-04-2011
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2007
    Posts
    109

    Re: Find and Replace

    I stand corrected. Sorry

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,123

    Re: Find and Replace

    @ Dionysos actually you can have muliple text colors/bold/font size in a single cell, provided the cell contents is pure text, entered as such (like a heading)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  6. #6
    Forum Contributor
    Join Date
    08-04-2011
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2007
    Posts
    109

    Re: Find and Replace

    Hence the "I stand corrected" comment.

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,123

    Re: Find and Replace

    ok cool, i didnt see your post, may have been a timing issue with the server

+ 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