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