Using conditional formating to copy range of cells
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. |
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. |
All times are GMT +1. The time now is 09:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com