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?