How can I make a format to follow the cell

D

Darren

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?
 
P

Pete_UK

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
 
D

Darren

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

Pete_UK

It seems that way ...

Pete

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







- Show quoted text -
Click to expand...
 
Top