Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need formula to show if a field hasn'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, and totals from those sheets will be displayed on the "main" sheet, which I will then access to finish my portion. Unfortunately, the other users may forget to update their portion, so I'd like to set a rule that changes the color of the text or displays a warning that the fields on the other sheets have not been updated on the current day. Is this possible, and if so, can someone tell me how to do it? -- telewats ------------------------------------------------------------------------ telewats's Profile: http://www.excelforum.com/member.php...o&userid=30270 View this thread: http://www.excelforum.com/showthread...hreadid=503466 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula in a writable field | Excel Worksheet Functions | |||
Using a MIN, MAX formula on a calculated field in a pivot table | Excel Discussion (Misc queries) | |||
Some formula results will not show up in the cell | Excel Worksheet Functions | |||
how to show formula in formula bar | New Users to Excel | |||
I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) |