Hey guys

Does anyone know if its possible (and how) to code/formula cell formatting between sheets?? I am only using a =Sheet2!A1 type set up and then dragging that across and down, which I know will only synchronize the cell value.

That is, I have a master sheet and quarterly worksheets (which are all synchronized to the master) what I ideally want is if I enter $100 in red bold font into a cell with blue fill then that's what i want to see in the corresponding cell in the master. But the master only reflects $100 in standard black font color i.e. no cell fill or red bold font?

Can this be done or is it a no go in Excel?

Cheers