Formating Excel functions

[MLRB]

Is there a way (when pulling a cell to another sheet by use of a formula)
that you can pull the same formatting from that cell to the sheet: Example,
copy cell 1 from sheet 1 to cell 1 in sheet 2. I do not only want to copy
the value/text, but the color formatting as well. Is this possible?

 

[Jim]

ya paste special

 

[Ron de Bruin]

Hi MLRB

No, not with a formula

But you can use this example, this is for printing but you can use it
for your problem also
http://www.rondebruin.nl/print.htm#non-contiguous

 

[MLRB]

Thank you for your help.

Hi MLRB

No, not with a formula

But you can use this example, this is for printing but you can use it
for your problem also
http://www.rondebruin.nl/print.htm#non-contiguous