Create Calculated column condition based on value from 5 other columns

Hello Community member,

                 I would like to create calculated column condition is based on value from 5 different columns.

   the data came from google form which driver will fill the form via dropdown list the informaton will be like in the example 

I want power bi to determine whether driver is ready for work.

EXAMPLE input and   expect result 

here is criteria condition  A - G

item in Red Color   result "NO GO"   

item in Yellow color result "Recheck"

item in green color result "Passed" 

  the formula should check one by one column  if only one column found red item  the result is "NO GO "   and if only one column found yellow item   the result is "Recheck"   if  column value  all are green item the result is "Passed"

the priority from highest to lowest  : RED > YELLOW > GREEN

I have attached pbix file for reference 

Sample File Download 

Thank you,

Best Regards,

JJ