View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JessP27 JessP27 is offline
external usenet poster
 
Posts: 13
Default Highlight Changes within cell

Good morning!
Using Excel 2003
I need to highlight the changes I've made as I'm making them within a
worksheet.

I'm revising a customer order, so I paste the original quantity in cell B2 -
for example 200. When I change the quantity to 225, I'd like the cell to
change color.

I've tried the Track Changes feature, and it appears that I have to click
the button each time I open the workbook. Not a big deal, but since there are
20+ sheets, it's a little tedious.

Is there a way to highlight (using fill) the changes made within a sheet?
Am I using Track Changes incorrectly?

Any info would be greatly appreciated.
Thanks,
Jessica