the sintaxis is somthing like this:
oxlsheet.range("A1:K1").interior.ColorIndex = 6
oxlsheet.range("A1:K1").FONT.ColorIndex = 3
the number for yellow i think is 6
to find out simple go to excel
start the macro recorder
chenge the coloe os a cell
stop the recorder and look at the code that it created.
Bernardo
>My application creates an Excel file. I need to make the 1st row of information in the Excel file appear yellow. I tried the following (for each cell):
>
> oleApp.cells(1,1).BackColor=65535
>
>..and a few other things that are clearly incorrect.
>
>Any help is greatly appreciated.
>
>Martha
B.D.H.