I am not sure whether you can change the entire sheet color to yellow.
But you can change the colors of individual cells to any color u want.
worksheet.Cells(row,column).interior.colorindex = 6
here 6 is for yellow.
http://www.geocities.com/davemcritchie/excel/colors.htm
you can use the above URL for other color indexes.
Last edited by xav.vijay; Jun 29th, 2009 at 7:24 pm.
Reputation Points: 10
Solved Threads: 6
Junior Poster in Training
Offline 52 posts
since Aug 2005