Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
??? Copy conditional formating | Excel Discussion (Misc queries) | |||
Conditional Formating a Block of Cells | Excel Discussion (Misc queries) | |||
conditional formating cells i Excel based on other cells values | Excel Worksheet Functions | |||
How do i copy conditional formating formulas from 1 row to rest | Excel Discussion (Misc queries) | |||
can i freeze conditional formating to copy to another worksheet | Excel Discussion (Misc queries) |