Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sound+color alert if cell changed in another worksheet
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. -- florinel ------------------------------------------------------------------------ florinel's Profile: http://www.excelforum.com/member.php...o&userid=33827 View this thread: http://www.excelforum.com/showthread...hreadid=545548 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Name a worksheet tab from cell in worksheet | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
Refrencing another cell in a worksheet that "could" exist | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |