Using conditional formating to copy range of cells

[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.

 

[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