how to have excel look at 4 columns and return the value of the colored cell

Hi,

Please refer to attachement.

I am looking for a way to look at Price 1, Price 2, Price 3 and Price 4 and return the value that is colored in Green to column named Price.

Your suggestions are greatly apprecicated.

Thanks
Frederique