Value based on Background Color

[Amit Punia]

Need a VBA coding where it will give the value of the cell if that particular cell's background color is GREEN. So if the value in A2 cell is "A" and the background color is GREEN then it should show the value "A" in cell B2. Want this for the whole column.
File attached.

 

[NARAYANK991]

Hi ,

See if this is OK.

Narayan

 

[Amit Punia]

Thanks a lot @NARAYANK991, The code is working absolutely fine