How can I make a format to follow the cell
 

A1 contains 5 with red background.
If I type in another cell, "=A1" then how can I force the new cell to show
the 5 in red background?

How can I make a format to follow the cell
 

A formula can only return a result, not a format.

If that red background is the result of conditional formatting,
however, you can apply the same CF rules to the destination cell to
get the same effect.

Hope this helps.

Pete

On Aug 18, 10:42*am, Darren wrote:
A1 contains 5 with red background.
If I type in another cell, "=A1" then how can I force the new cell to show
the 5 in red background?

How can I make a format to follow the cell
 

Thanks mate - so I guess I just have to keep writing macro after macro to get
over the short comings of Excel :-)



"Pete_UK" wrote:

A formula can only return a result, not a format.

If that red background is the result of conditional formatting,
however, you can apply the same CF rules to the destination cell to
get the same effect.

Hope this helps.

Pete

On Aug 18, 10:42 am, Darren wrote:
A1 contains 5 with red background.
If I type in another cell, "=A1" then how can I force the new cell to show
the 5 in red background?

How can I make a format to follow the cell
 

It seems that way ...

Pete

On Aug 18, 1:31*pm, Darren wrote:
Thanks mate - so I guess I just have to keep writing macro after macro to get
over the short comings of Excel :-)



"Pete_UK" wrote:
A formula can only return a result, not a format.

If that red background is the result of conditional formatting,
however, you can apply the same CF rules to the destination cell to
get the same effect.

Hope this helps.

Pete

On Aug 18, 10:42 am, Darren wrote:
A1 contains 5 with red background.
If I type in another cell, "=A1" then how can I force the new cell to show
the 5 in red background?- Hide quoted text -

- Show quoted text -