ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Copy cell formating as part of a formula (https://www.excelbanter.com/excel-worksheet-functions/15934-copy-cell-formating-part-formula.html)

KepGuru

Copy cell formating as part of a formula
 
I don't know if there is anyway to do this.
Is there any formula that will copy a cells formating as well as the value?

The goal is to have value and formating changes in one spot, are reflected
in the entire spreadsheet.

Peo Sjoblom

Formulas can never copy formatting You would need VBA for that

--

Regards,

Peo Sjoblom


"KepGuru" wrote in message
...
I don't know if there is anyway to do this.
Is there any formula that will copy a cells formating as well as the

value?

The goal is to have value and formating changes in one spot, are reflected
in the entire spreadsheet.





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

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