Formatt of cell filled by formula

  • Thread starter Thread starter Madhvi
  • Start date Start date
M

Madhvi

I have a summary sheet a the begining of a workbook. This sheet picks up the
contents of cells through different each worksheet by a formula eg
='sheetname'!E5. How can I get this to also pick up the formatt of the cell,
specficaly the colour of text.

Thank you
 
If the source cells are colored due to Conditional Formatting you can also
CF the destination 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

Printing in Excel 1
Conditional Formatting!!! 4
Excel Count If Formula Question 1
problems getting this macro to work 23
Can someone help 1
Possible Indirect query 1
Formula from a single cell to a merged cell 4
Formula is too long, (error message) 3

Back
Top