Conditional paste, based in colour.

[Closed]
Report
-
Hello,
I'm looking to copy one value in one cell, following this condition:

If A1 is green, then copy the value of C1 in B1. If not, leave it blank.

I have a list of numbers in Column A, but just the green ones have the data I need in Column C, so the data must be copied to Column B, ignoring the blank ones in Column A.

Thanks