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
Hope this helps.
On Feb 23, 3:56=A0pm, JessP27 <Jess...@discussions.microsoft.com> wrote:
> Good morning!
> Using Excel 2003
> I need to highlight the changes I=92m making within a cell.
> For example: In cell B2, is the customer=92s original order quantity of 2=
> revise it to show 225 and I=92d like the cell to be highlighted in yellow=
> can then copy and paste the info into an email to show the customer which
> items have been revised.
> I=92ve tried using Track Changes, but it seems that I have to click on th=
> Track Changes button each time I open the workbook. It also doesn=92t kee=
> revision highlighted for a copy and paste.
> I have 20+ worksheets within the workbook and would like to update each o=
> and have the process relatively automated.
> Is there a way to accomplish this?
> Thanks in advance,