Conditional formatting from a chart to a table.

Hello vgubarev and Welcome to Excel Forum.
This proposal employs helper columns P:Z which may be moved and/or hidden for aesthetic purposes.
The helper columns are populated using: =VLOOKUP(B2,Results!$A$1:$B$9,2)
The conditional formatting rules for B2:N14 are:
For green: =P2="Passed"
For red: =P2="Failed"
The conditional formatting rules for A2:A14 are:
For yellow: =AND(COUNTIFS(P2:Z2,"Passed")>0,COUNTIFS(P2:Z2,"Failed")>0)
For red: =COUNTIFS(P2:Z2,"Failed")>0
For green: =COUNTIFS(P2:Z2,"Passed")>0
Let us know if you have any questions.