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?