Lookup and Conditional formatting

Hi,
I'm hoping to get some help with a lookup formula.
I have in Sheet1, contract numbers in column A that I need t lookup in Sheet2, for each Colum B to E in sheet1, if the corresponding Column in Sheet2 is conditionally formatted Green, then "Yes" on Sheet1 needs to be written and if Sheet2 is formatted RED, then "NO" needs to be written in Sheet1.

I have attached a sample worksheet for reference.

Looking forward to your assistance and thank you in advance!