Retaining format using cell references

[renovator]

Hi,
I volunteered to help at an aged care home.
The Nurses write down notes about each patient in a single cell about feeding , allergies and special notes . Allergies are in red. They use alt+enter to do soft returns

They combine all the notes using simple cell references e.g. = patient!A1, but when they do they lose the colour and the fonts the soft returns. Both the original cell and the new cell are word wrapped

regards Renovator

 

[Rijnsent]

Hi Renovator,
what is your question? Just by referencing to the cell it's not possible to take over the formatting AFAIK.
Cheers,
Koen

 

[renovator]

Dear Koen,
Is there a formula that can I use to carry across formatting ?

 

[Rijnsent]

Hi Renovator,
that is unfortunately not possible AFAIK.
Koen

 

[Joe4]

To do anything like that would probably require VBA.

Unless, if the coloring is originally done with Conditional Formatting, you can use the same Conditional Formatting rules to apply it on the other sheet too.
But if the coloring was done manually, you are probably going to need VBA to do it. Native Worksheet Excel formulas only return values, not formatting.