|I don't think there is a simple way to do what you want. The only way to get formatting from one place to the next is to manually copy and paste/special/formats. Another way might be to use conditional formatting so long as the same conditions exist in the different sheets but this doesn't seem to be the case in your example.|
We might be able to write a macro to do this but I suspect that may take longer than actually doing it manually. However, if you want to follow up on the macro option we would need much more detail on the structure of your spreadsheets and how they relate.