Conditional paste, based in colour.

Malfreds - Aug 29, 2016 at 08:09 PM
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.