referenced cells

[Michaeld]

I have a cell e.g. A1 which contains data e.g 123 which is formatted in red.
When I refer to that cell from e.g B1 with the formula =A1, it returns 123,
but not formatted in red.
What formula can I use to return both the data and the formatting of the
referred cell please?

 

[Harald Staff]

That is not possible. A formula can only return a value.

Best wishes Harald