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.

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.

Thanks for your input.

"Bernie Deitrick" wrote:

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.

Bill,

You could use Conditional Formatting, but it would show up as red whenever
the cell contained "Workorders Approved" even if it didn't have "Workorders
submitted" prior to that. The cell could contain no other text. In the
latter case, an event macro would have to do the red formatting.
--
Earl Kiosterud
www.smokeylake.com

"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.