![]() |
Show cells have been read - linked
I have several (10 different companies) workbooks reading (linked through
"SUM") a sales forcast from another workbook called SALES. I have highlighted the linked cells in the 10 individual workbooks to show which cells are linked and update automatically. BUT... now I need to see which cells in the SALES workbook have not been read into the individual ones so I can check which cells have not been read yet. How would I go about differenciating between cells that have or have not been read? Is there a conditional format or a formula that would work? Thanks in advance for any help you can offer |
All times are GMT +1. The time now is 12:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com