Using conditional formating to copy range of cells

H

HTawb

i understand condition formating:
=if(a1=1, "one", "wrong")
but this is what i'm trying to do:

=if(a1=1, [copy the range of cells of a12:a14], "wrong")
where [copy the range of cells of a12:a16] and paste them to the range of
A3:A6.

OR
i want to place a 1, 2 3, or 4, in cell A1 and then cells A3:a6 gets filled
in with info from a12:a14.
 
G

Gord Dibben

Formulas cannot "copy" anything.

They can only return results to the cell in which they reside.

You would need formulas in A3:A6 to return data from A12:A14 based upon the
number in A1

Note:A4:A6 is 4 cells.............A12:A14 is three cells..........A12:A16 is
five cells.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top