[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[_2_]]

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

Best wishes Harald

"Michaeld" wrote in message
...
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?

[David Biddulph[_2_]]

You can't.
--
David Biddulph

"Michaeld" wrote in message
...
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?