ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Is there a way to transfer a style by cell referrence in a formula (https://www.excelbanter.com/excel-discussion-misc-queries/854-there-way-transfer-style-cell-referrence-formula.html)

Binki55_CanYouHearMeNow

Is there a way to transfer a style by cell referrence in a formula
 
I wish to copy the contents of some cells into other cells by cell referrence
(formulas) but don't know how to copy the styles at the same time. Is there a
way to do this without having to copy styles one cell or cell group at a time
?

Frank Kabel

Hi
formulas can't copy formats

--
Regards
Frank Kabel
Frankfurt, Germany

"Binki55_CanYouHearMeNow"
schrieb im
Newsbeitrag ...
I wish to copy the contents of some cells into other cells by cell

referrence
(formulas) but don't know how to copy the styles at the same time. Is

there a
way to do this without having to copy styles one cell or cell group

at a time
?




All times are GMT +1. The time now is 05:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com