Finding first green and return value in column to the right

[Esinko]

Hi,

I'm trying to find the first green colored cell in a column, and then return the value of the cell directly to the right.

E.g. if first green cell was A2, it would return the value of B2.

Any help on this would be greatly appreciated!

Cheers,

Sinko

 

[sadboy309]

I can use Name Define and Match array first cell, return this Row and use this row into column B, return Cells(B,first row).