Conditional paste, based in colour.

[Closed]

Report

Malfreds - Aug 29, 2016 at 08:09 PM

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

Conditional paste, based in colour.
Copy & Paste based on specific condition ✓ - Forum - Office Software
Excel conditional formatting based on date in another cell - How-To - Excel
Excel conditional formatting based on another column ✓ - Forum - Excel
How to use conditional format based on text? ✓ - Forum - Excel
Conditional format based on text in same row ✓ - Forum - Excel

Conditional paste, based in colour.

Your reply

Subscribe To Our Newsletter!