Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
109
Views
Topic starter
When using ="sheet name"$A$1 as a formula in a different sheet how do you copy the formatting of the master cell to the slave as well?
Posted : 17/10/2019 6:15 pm
Hi Chris,
Formulas do not copy formatting, they only copy the underlying cell value. If you want formatting applied, you need to either do that manually, or use VBA to automate it.
Mynda
Posted : 17/10/2019 7:26 pm
