Highlight changes within cell - 137410

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
0
Utf
2/23/2010 3:56:15 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
1555 Views

Similar Articles

[PageSpeed] 43

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

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=
00. I
> revise it to show 225 and I=92d 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=92ve tried using Track Changes, but it seems that I have to click on th=
e
> Track Changes button each time I open the workbook. It also doesn=92t kee=
p the
> revision highlighted for a copy and paste.
>
> I have 20+ worksheets within the workbook and would like to update each o=
ne
> and have the process relatively automated.
>
> Is there a way to accomplish this?
>
> Thanks in advance,
> Jessica

0
Pete_UK
2/23/2010 7:04:44 PM
Reply:

Similar Artilces: