Color Updated Text

Is there a macro that can color the specific text in a cell that has been updated? Currently, I am using some conditional formatting as a temporary solution, but it colors all of the text in a cell if a change is detected.

I plan on having another macro that will color all of the text in the sheet black after I have reviewed the changes.

This proposed method is similar to the "track changes" feature in Excel, but I would like something that visually points out the specific text.

See the attached file for an example of what I would like the macro to do. Column B shows the initial text in the cells and column C shows what the text color in these cells should look like after updates are made by the user.

Any thoughts?

You said that it might be possible to color the new words in the cell a color. Is there a solution for this? I don't really care about tracking changes for the deleted text. Just coloring the text that is being added in while leaving the original black.

Thanks for the help. I appreciate it.