You just need to copy the format, and paste it to the other cells really. Note that the range that you define should have the same naming convention as the ranges I've mentioned above. That's why the INDIRECT("rng"&B2) works as rngTransfer range.