| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
| put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
| using content of a cell in a formula in another cell | Excel Worksheet Functions | |||
| to copy a formula in cell c1 (+b1/b11) to cells c2-10, how can i . | Excel Worksheet Functions | |||
| Aligning Two Lists in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
