| 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. |
| 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) | |||
Threaded Mode
