Hi Don't
This is not possible with a worksheet function
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Don't" wrote in message ...
I have a woorkbook that has a list of movies, all in column A. In the rest of
the columns I use =A9 and so on. The info goes to the cells just fine but I
would also like it to take the color of the text! Is this possible?