Table joins

[#1]

Hi there,

I have the below issue.

I have this table with a field 'task dependency'. This is populated in an Excel sheet.

In a separate Excel sheet, I have task detail - and 'Task 1' will appear in there. How can I make it so that the contents of 'Task Dependency' link to the contents of the 'tasks detail' sheet?

Basically, if the RAG status in the 'task detail' sheet is red, I want the task name in the task dependency column to show in red.

Can you help?