| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I copy cell attributes between worksheets
I have a master worksheet with several worksheets that feed the master. I am
using the formula if(xyz!a5="","",xyz!a5) to copy the data. How do I copy the attributes (fill color)? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I copy cell attributes between worksheets
Any formulas including linking formulas cannot do more than pull values.
If the source cells are colored due to Conditional Formatting you could add that to the target cells. Gord Dibben MS Excel MVP On Wed, 21 May 2008 16:40:00 -0700, charlesm wrote: I have a master worksheet with several worksheets that feed the master. I am using the formula if(xyz!a5="","",xyz!a5) to copy the data. How do I copy the attributes (fill color)? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transferring formatting attributes to another cell. | Excel Discussion (Misc queries) | |||
| Cell attributes | Excel Discussion (Misc queries) | |||
| Data value display attributes linked to table attributes | Charts and Charting in Excel | |||
| Can I modify cell attributes (font,color etc.) based on function . | Excel Discussion (Misc queries) | |||
| How do I copy page set up attributes from one worksheet to anothe. | Excel Worksheet Functions | |||
Linear Mode
