Bill,

There is no way to do that with built-in Excel functionality. And writing code to do it would be
problematic.

You could look at Tracking Changes, which will highlight changed cells.

HTH,
Bernie
MS Excel MVP


"Bill" wrote in message
...
Using VBA, I need to automatically change the color of the exact text that
was changed within a cell to red.

Example:

A cell contains the text "Workorders submitted." If the same cell is changed
to read "Workorders Approved." Then the work "Approved" would can to red.