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.