Thanks, but that doesn't work,

If I can explain a little clearer.

The following example would be workable for me.

In cell a1 I have a formula =summary!a1
in b1 is have =summary!b1

You will see that these cells are in the same workbook but a different
worksheet


in a2 the formula is ='[Uploaded.xls]Sheet1'!$a$1 - (here the formula is
looking at a different workbook)

and so on

In cell c1 I would like the formula to be based on the formula in a1. If a1
is pointing to the summary sheet then I would like the c1 to say "not
uploaded"

However, if the formula is pointing to the uploaded spreadsheet then I would
like c1 to say "uploaded"

So if the formula in c1 is copied down to c2 then c2 would say "uploaded"
because A2 is looking at the uploaded workbook.

I tried the find function by putting the following formula in cell c1

=find("uploaded",a1) and the cell showed #VALUE!

Hope this clears up what I am after.






"Jim Rech" wrote:

Doing a Find on the other workbook's name will 'highlight' (select) each
such link one at a time.

--
Jim
"Michael" wrote in message
...
| Hi, I have a worksheet with some rows that are linked to a different
| worksheet within the same workbook and some rows that are linked to a
| different workbook.
|
| The worksheets all have unique names
|
| Is there a way that I can highlight the cells that are linked to a
different
| workbook please? Alternatively I could have a column that says whether
that
| row is linked to an external workbook.
|
| Thank you in advance
|
|
|