The only way is to do this

See the example in my print tip
http://www.rondebruin.nl/print.htm#non-contiguous

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



"Beard" wrote in message ...
Okay, I'm referencing cells from another worksheet, and I want to keep the
same formatting from the "other" worksheet. So if the text is Red on one
sheet, I want it to be red when it is referenced on the other. Any help?

Thanks.
--
Brad