Using conditional formating to copy range of cells
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
On Fri, 22 Jun 2007 13:04:00 -0700, HTawb
wrote:
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.
|