How to apply table conditions

[#1]

Hi there,

I wonder if you can help.

I have a table like below:

Dependency Name	RAG Status	Dependent on Task:
dependency 1		Task 1

I have another table that says:

Task Name	RAG Status
Task 1	Red

I would like to be able to say "IF TaskTable.Task1 = 'RED' then DependencyTable.Dependency1 should equal red AND the cell should turn red accordingly

Can you help?