Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to track cells that haven't been updated
I'm working on a spreadsheet that pulls data from separate sheets within the same file. The data in the other sheets will be updated daily by other users (each user will access the sheet, enter a date in 'their' field, and then save/close the spreadsheet), and then totals from those sheets will be displayed on the "main" sheet, which I will then access to finish my portion. Since the other users may forget to update their portion on time each day, I'm trying to to find a way to change the color of the text or display a warning that the fields on the other sheets have not been updated on the current day. For instance: Sheet A is my 'master' sheet and has totals from Sheets B & C. Sheets B & C are updated by other users. I'd like a note or color change in the fields of Sheet A that warns me that the necessary fields on the other sheets have not been updated on the current day. I think this would be done through a Change Event...? However, I'm not familiar at all with this feature, so can someone help me with this? -- telewats ------------------------------------------------------------------------ telewats's Profile: http://www.excelforum.com/member.php...o&userid=30270 View this thread: http://www.excelforum.com/showthread...hreadid=504536 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to track cells that haven't been updated
Hi telewats. On your master sheet, assuming that a user enters a date on
sheet C in A1, you could have this in a cell on your master sheet: =if(TODAY()C!A1,"Not updated yet",""). HTH -- Sincerely, Michael Colvin "telewats" wrote: I'm working on a spreadsheet that pulls data from separate sheets within the same file. The data in the other sheets will be updated daily by other users (each user will access the sheet, enter a date in 'their' field, and then save/close the spreadsheet), and then totals from those sheets will be displayed on the "main" sheet, which I will then access to finish my portion. Since the other users may forget to update their portion on time each day, I'm trying to to find a way to change the color of the text or display a warning that the fields on the other sheets have not been updated on the current day. For instance: Sheet A is my 'master' sheet and has totals from Sheets B & C. Sheets B & C are updated by other users. I'd like a note or color change in the fields of Sheet A that warns me that the necessary fields on the other sheets have not been updated on the current day. I think this would be done through a Change Event...? However, I'm not familiar at all with this feature, so can someone help me with this? -- telewats ------------------------------------------------------------------------ telewats's Profile: http://www.excelforum.com/member.php...o&userid=30270 View this thread: http://www.excelforum.com/showthread...hreadid=504536 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to track cells that haven't been updated
I think this formula would work for me. Just one question, though. Can I use multiple criteria with the IF function, and if so, how would I write the formula for this? -- telewats ------------------------------------------------------------------------ telewats's Profile: http://www.excelforum.com/member.php...o&userid=30270 View this thread: http://www.excelforum.com/showthread...hreadid=504536 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updated cells | Excel Worksheet Functions | |||
Conditional formatting...cont. from 9/25 | Excel Discussion (Misc queries) | |||
Display first, second, etc Nonblank Cells in a Range | Excel Worksheet Functions | |||
copy & paste spreadsheet cells from excel to outlook to excel | Excel Discussion (Misc queries) | |||
If formula that looks at multiple cells and values, and then calul | Excel Discussion (Misc queries) |