Formatt of cell filled by formula

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
 
G

Gord Dibben

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

Dealing with the error: unable to filter on excel hc home school 0
Dumb question alert! What program to use? 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Can someone help 1
Simple IF Statement Help! 3
complicated excel formula may need an algebra wiz 1
Formula to check presence of value between sheets 7
Macros to check whether all cells are filled 0

Top