How do I copy cell attributes between worksheets

C

charlesm

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)?
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tie additional cells to cell automatically updated 1
Dispaly results, rather than a formula 2
copy a cell from multiple worksheet 3
Copy Data between worksheets 1
Excel VBA 1
Problem searching cell text 3
Graphing data from multiple worksheets in same workbook 1
Sum multiple sheets? 1

Top