+ Reply to Thread
Results 1 to 4 of 4

To compare texts in two cells and highlight the changes

  1. #1
    Registered User
    Join Date
    10-22-2014
    Location
    USA
    MS-Off Ver
    7
    Posts
    5

    To compare texts in two cells and highlight the changes

    Hi,
    If i have two columns containing the original text and changed one ,how can i highlight in the below colors
    1. text added : green
    2. text deleted : red
    3. text modified: any other color

    Note: We can use any other color as well.

    Please help me figure out the solution as i am finding it tough to find the changes as the document is exhaustive.

    Please find the example attached
    Attached Files Attached Files

  2. #2
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: To compare texts in two cells and highlight the changes

    You can try this macro. It supposes all the text is in those 2 cells A2 and B2:
    Please Login or Register  to view this content.
    It does not take into account if a word appears more then once. It would be hard to follow and compare a long text with words appearing multiple times. It could be difficult for a person to do, imagine a computer.
    Attached Files Attached Files
    Last edited by p24leclerc; 04-09-2015 at 07:14 PM.
    Pierre Leclerc
    _______________________________________________________

    If you like the help you got,
    Click on the STAR "Add reputation" icon at the bottom.

  3. #3
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: To compare texts in two cells and highlight the changes

    If you have multiple cells in column A and B to compare, then the following macro will scan all rows in those columns.
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    10-22-2014
    Location
    USA
    MS-Off Ver
    7
    Posts
    5

    Re: To compare texts in two cells and highlight the changes

    Thanks a lot. This works

+ 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. [SOLVED] To average cells included texts - how to ignore texts in those cells - help please
    By PrayoonD in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-23-2014, 12:32 PM
  2. Replies: 1
    Last Post: 12-13-2013, 10:28 PM
  3. [SOLVED] compare cells and highlight same
    By shart2k12 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-05-2013, 01:34 PM
  4. Compare 2 cells in a worksheet and highlight if different?
    By loulouk in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-17-2012, 01:44 PM
  5. Compare Columns and Highlight Cells
    By Daker3 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 09-13-2012, 11:22 PM

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