Hi!
I have 2 worksheets. In the first one I enter data regularely and in the second one never because it gets data from the first one (but rarely is changed something here since it keeps track of maximum and minimum values from first worksheet). I want a way to know at the time I enter data in worksheet 1 if something has changed in worksheet 2 (the way I would prefer the alert here would be a beep or an autoplay of a little .wav file) then when I go to worksheet 2 I want to easily locate the newly changed values by having their cells background in red for a certain amount of time (lets say 24 hours - so only if their values changed today, or in red until the workbook is closed). The cells in worksheet 2 I'm talking about are D3:D23. How do I do that ?

Thanks.