When linking to a cell in another sheet the number or text will come up; but
without the original format.

How can I make a rule or function that gets the value from nother cell +
also shows the format from that cell (example: if the text is in red in the
original cell - how can I make it red in the other cell - and when changing
the color to blue in the original cell this should happen in the other cell)