Thank you for your help.

"Ron de Bruin" wrote:

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



--
Regards Ron de Bruin
http://www.rondebruin.nl


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