Hi there,

I'm very new at this so please bear with me....

I'm trying to find a method to color the background cells in my worksheet, format a cell so that it displays the date in the following format: "Nov-2005", and finally to format the number of decimal places displayed in some selected cells. Any ideas?

For the date problem, I'm not sure if I'm on the right track :

.range("A1").numberformat = " ????? "

Similarly for the decimal places prob, should I be using the .numberformat method??

Any help would be appreciated.