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
1520 Views

Similar Articles

[PageSpeed] 12

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:

Search file and within the file
Hi, I have several files in a folder most of them are CVs in word format, I want to create a query or access program to get the subject with some criteria - any ideas? If I search for a particular Text, that should check and matching file name and also inside the word file. I tried google desktop search, coppernic search and even the MS Search - but nothing helped in a way I want. I appreciate your valuable time. Rgds Anver, To develop a bespoke Access application will take much effort and involve using Windows APIs. I suggest you don't want to do this. Instead consider upgrad...

Table Changes
Where is the documentation for the table changes for GP 9 It should be in the help menu. Gerald "Brian" wrote: > Where is the documentation for the table changes for GP 9 > I have yet to install it.. I am trying to make sure that I have everything covered do to the fact we have numerous outside apps that talk to the backend of GP and want to prevent any possible headaches Gerald wrote: > It should be in the help menu. > > Gerald > > "Brian" wrote: > >> Where is the documentation for the table changes for GP 9 >> Brian, What...

What is the cell data reference for 5th row and 7th column called
Can someone help me with this question? I need to get the answer for my homework. Thanks for your help. I'm guessing, but might it be G5? -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Shy-di@verizon.net" <Shy-di@verizon.net@discussions.microsoft.com> wrote in message news:A0979494-228B-435E-98F7-6BD26C900266@microsoft.com... > Can someone help me with this question? I nee...

Cell Contains Data.
How can I tell a cell that IF a cell contains data (numbers, text, whatever) do x or y. How can I identify data?? I don't want to tell the function to look for a specific number or text, just data, just something in the cell... =IF(A1<>"","Data","No Data") "GEM" <GEM@discussions.microsoft.com> wrote in message news:07916799-F312-4E89-A926-59356B74ED89@microsoft.com... > How can I tell a cell that IF a cell contains data (numbers, text, > whatever) > do x or y. How can I identify data?? I don't want to tell the function ...

Active cell highlight
Hi, I would like to know if there was a way to have an active cell always in yellow or any color. Example: If the active cell is moved around, the active cell will be always in yellow. Thank you in advance maybe.... you may want to try Chip Pearson's Rowliner: http://www.cpearson.com/excel/RowLiner.htm E wrote: > > Hi, > > I would like to know if there was a way to have an active cell always in > yellow or any color. > > Example: If the active cell is moved around, the active cell will be always > in yellow. > > Thank you in advance -- Dave Pet...

Need to separate multiple numbers in one cell
I have multiple number in one cell and i need to somehow put each number into one separate cell for each number: I have : column A row1 2 5 8 10 I want: column B column C column D column E row1 2 5 8 10 How do I do it on Excel 2007? thanks EggHeadCafe - Software Developer Portal of Choice Map Stored Procedure Output To Class Properties http://www.eggheadcafe.com/tutorials/aspnet/2853a1aa-5db7-40d0-9cde-46847fa770ef/map-stored-procedure-outp.aspx Hi, Use Data > Text to columns and specify the delimiter as space ...

copy value in cell above to cell below for a whole column
I have a spreadsheet that was saved from a report. this report only lists the employee name once. There is a way to copy the value of the cell above to the cell below. I can get as far as highlighting the blank cells with the Go To function, then I can not remember the steps to tell excel to copy the data into the blank cells. Can anyone help? Ctrl+D will copydown the value of the top cell to the highlighted cells below. "tarthur" wrote: > I have a spreadsheet that was saved from a report. this report only lists > the employee name once. There is a way to copy th...

How can I remove the previous lock cells and keep the new ones.
Could you please help me?... I locked and protected the cells A1:H20 in the sheet 1 two months ago. However, yesterday I wanted to unlock and unprotect these cells and locked and protected the cells A21:H40 instead. However, for some reason the cells A1:H20 are still lock and protect. How can I remove the previous lock cells (A1:H20) and keep the new cells (A21`:H40) only. Thanks. Maperalia In EXCEL 2007 take the following actions to unlock cells A1 to H20:- 1. Home / Cells group / Format / Unprotect Sheet / enter the password to Unprotect Sheet / OK / highlight cells A1 t...

formulas changing when emailed
At work, I have created a spreadsheet that has links to workbooks in a user drive..called the "U: drive." When I transfer this excel project to others via email, I make sure that the other workbooks also have the same name in their U: drive as well. However, whenever I email it... I have to change many of the formulas at their computers bc the references in my formulas change to a really long string. I have tried using "CNTL+H" to replace the "=" to a "+" but it doesn't work for me bc I have "+" "=" elsewhere in my formulas....

Adding data from multiple cell and linking to a new worksheet
I have data in a sheet with names and amounts due. Like A 500 B 300 A 600 B 300 C 400 C 200 There is a second sheet named summary. I want the totals of each person to appear in the summary sheet. These should be linked cells and any change in data in sheet 1 should be updtaed automatically Create a PivotTable http://www.ozgrid.com/Excel/excel-pivot-tables.htm -- Regards Dave Hawley www.ozgrid.com "Rashmi" <Rashmi@discussions.microsoft.com> wrote in message news:56DC0F3A-8D60-4FE2-B778-3A07790EFE8A@microsoft.com... >I have data in a sheet wi...

Move cells down to match cells
A B C D E 1 000801025-8 009601025-3 2007 000801025-8 2007 2 000801026-9 009601026-4 2004 000801026-9 2004 3 000801028-1 009601028-6 2006 000801028-1 2006 4 000801036-8 009601036-3 2008 000801036-8 2008 5 000801044-5 009601044-0 2007 000801044-5 2007 6 000801044-5 009601055-0 2004 000801055-5 2004 7 000801055-5 009601064-8 2001 000801064-3 2001 8 000801055-5 009601091-2 2006 000801091-7 2006 9 000801064-3 009601095-6 2002 000801095-1 2002 10 000801091-7 009601097-8 1998 000801097-3 1998 11 000801091-7...

using data from another cell
I would like to type a name in one cell(1) then check in list (different column) if the same name is there, and if it is there get a value of another cell locate in the same row where. Can some one help me? Create your second list and use VLOOKUP as follows: Name is typed in: A1 List of names and values in: C1:D10 =VLOOKUP(A1,$C$1:$D$10,2,FALSE) "leo" <reani1996@hotmail.com> wrote in message news:OiO5fCTWDHA.2268@TK2MSFTNGP11.phx.gbl... > I would like to type a name in one cell(1) then check in list (different > column) if the same name is there, and if it is t...

How to exclude cells from a datasource?
Hi, I have an XY chart in excel97 that uses a range of cells for the data source. Every now and then I would like to exclude a XYnode from the chart. Without having to reselt the datasource. Is there a value one can enter in the cell that exludes it from the graph (compare: putting text in a cell excludes it from the SUM() function). For example point X Y a 1 1 b 2 2 c 3 3 Gives a graph with two lines connecting the three points While point X Y a 1 1 b ? ? c 3 3 Should give a graph with one line connecting point a and c. Point b is left out. Or is the...

What must I do to get gridlines printed for both filled and empty cells?
Hi, What must I do to get gridlines printed for both filled and empty cells? I'm a teacher, and I'm trying to replicate and print, in Excel, an attendance book format, with a series of tiny squares next to each student's name. The printed form of this would allow me to register if a student were present or absent on a particular day. Hubert -- Hubert Earl, vendor of fine Jamaican art, coffee, etc. on eBay: http://www.stores.ebay.com/id=12295024&ssPageName=L2?refid=store; Fine Jablum Blue Mountain Coffee sales page: http://stores.ebay.com/Jamaican-Coffee-Art-and-More-Store_Jab...

Excel Cell Formatting #3
How do I centeer a picture in an Excel cell? Hi you can't as such objects 'float' above the cells in Excel -- Regards Frank Kabel Frankfurt, Germany "Tom Coffey" <Tom Coffey@discussions.microsoft.com> schrieb im Newsbeitrag news:8E7356E1-4318-42F3-B9C6-3D7EDFBBEEA1@microsoft.com... > How do I centeer a picture in an Excel cell? ...

Chart changing based on change in data source (number of rows/colu
As I see, the data range for charting is normally fixed. I have to produce chart based on chaning rows and/or columns in data source table. Has anybody got some suggestion for me? Bal Ram Bhui - For Excel charts in general, I suggest Jon Peltier's web site: http://www.peltiertech.com/ For dynamic charts, I suggest: http://www.peltiertech.com/Excel/Charts/Dynamics.html - Mike Middleton http://www.DecisionToolworks.com Decision Analysis Add-ins for Excel "Bal Ram Bhui, Jakarta" <Bal Ram Bhui, Jakarta@discussions.microsoft.com> wrote in message news:DD0B5564-26B0-4...

Cell possibilities?
Hi, I have a spreadsheet which has dates when people have attended a course. The sheet then updates itself through conditional formatting and formulas to let me know when course dates have run out. Is it possible through using either a formula or conditional formatting that after a certain time period e.g. two months after a course date has run out, that the date in the cell is erased? If so how id it done? Thanks in advance. What formulas and conditional formulas are you presently using to determine when course dates expire? And what exactly do you mean by "erased"? Do you me...

How can i change tab control 's background color
I create a class derived from CTabCtrl. If i handle the WM_PAINT message, there're nothing left on the control. Does it mean that I should draw all the things? And the WM_CTLCOLOR doesn't work,too. How can I change the background color simply? ...

How to change the Volume 1, Issue 1 template
How do i change and work with volume, and issue template in Publisher? everytime i click on it it wont let me change the numbers. does this work by itself? how do i work with this feature? is there a tutorial that discusses this item? You double-click on it and then you can change anything you want. -- JoAnn Paules MVP Microsoft [Publisher] "hotmail problems" <hotmailproblems@discussions.microsoft.com> wrote in message news:19CDFE4F-E793-417D-AF54-E0EE99382CEC@microsoft.com... > How do i change and work with volume, and issue template in Publisher? > everytim...

cells don't adjust
when worksheet is sorted the corresponding cells or the cells linked to the right, don't move with them. they stay in the same spot. Also this is a big work group with worksheets that are linked and referenced together.... In other words the cells to the right of the cells be sorted don't shift down when I sort the page. If you need meto explain more I can! "boraguru" wrote: > when worksheet is sorted the corresponding cells or the cells linked to the > right, don't move with them. they stay in the same spot. Also this is a big > work group with work...

Ability to change parent account for National Account children
I have several clients using National Accounts that have a need occasionally to be able to change the parent account for child customers. For one client, the need arises when detists change affiliation from one practice to another and the client wants to maintain history across all parent affiliations. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Mic...

Changing coler of tracking cells
When I use "track changes" the changed cells are outlined in lavender which is really hard to see. Is there a way to change the highlight color to a darker one? ...

To display number in text format in cells
I have a sequence of digits like 5026555306553 I entered in a cell and when the cursor left the cell it displays as 5.02656E+12 How do I set the cell or the whole spreadsheet to display as text rather than this format? Change the cell format to either: Number Accounting or Currency. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Man T" <alanpltse_NOSPAM@yahoo.com.au> wrote in messag...

Why only font size is changed?
i have try to change the font of the win32 common controls, such as tabbar, edit control. but, it seems that only the font size is changed. i tried to replace the default font of edit control and tabbar to "Tahoma" and "Verdana" with some sizes. but the results are both as i mentioned previously. -- Frank F.Han +-----------------------------------------+ | winsays@:-)hotmail:-).com | +-----------------------------------------+ Frank, The psychic ablilities in this group is below par, I'm sad to say. It will be easier to give you an answer if you show so...

Displaying Color in Cells
Help -- I just installed Office 2003 and when working in Excel am unable to select a cell for color. I know how to do this (under normal circumstances) but the Excel on this computer will NOT accept color! I tried opening up a document created on another PC (Office 2003) that had color in cells and the color DID NOT SHOW. I am also unable to change font color. So it seems that color formatting is not working. Any ideas? WK If this is a problem with all files with coloured cells, the Windows OS high contrast setting may be turned on. There is information in the following MSKB art...