| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can cells containing linked formulas be identified? | Excel Discussion (Misc queries) | |||
| can I get cells with a minus number to show zero | Excel Discussion (Misc queries) | |||
| Heavily linked spreadsheet freezes with "calculating cells 0%" - . | Excel Worksheet Functions | |||
| How to keep linked cells blank until information is entered? | Excel Worksheet Functions | |||
| Sorting mixed up linked cells in a workbook? | Excel Worksheet Functions | |||
Linear Mode
