Highlight changes within cell

[JessP27]

Good morning!

Using Excel 2003
I need to highlight the changes I’m making within a cell.

For example: In cell B2, is the customer’s original order quantity of 200. I
revise it to show 225 and I’d like the cell to be highlighted in yellow. I
can then copy and paste the info into an email to show the customer which
items have been revised.

I’ve tried using Track Changes, but it seems that I have to click on the
Track Changes button each time I open the workbook. It also doesn’t keep the
revision highlighted for a copy and paste.

I have 20+ worksheets within the workbook and would like to update each one
and have the process relatively automated.

Is there a way to accomplish this?

Thanks in advance,
Jessica

 

[Pete_UK]

If you copy the quantity column to another column, then this could act
as an "old_quantity" column. thus if you change the existing quantity
from 200 to 225, then you could have conditional formatting to
highlight the cell if it is not the same as the old_quantity. You
would need to copy the new quantity across to the old quantity at some
stage.

Hope this helps.

Pete