Hi
have a look at the following properties:
range.inerior.colorindex
range.font.colorindex
range.bold


--
Regards
Frank Kabel
Frankfurt, Germany

"Bart van den Burg" schrieb im Newsbeitrag
...
Hi

how can I, in VBA, give a color to cells, text in cells, and make
texts in
cells bold?

thanks