Can you do anything so cell formatting e.g. font colour and fill colour synchronises betwe

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

I have come across similar requests and have offered what I refer to as a "workaround".
Not sure if it would work for you - can you attach a basic copy of your workbook, obviously desensitised.
Regards
peterrc