Articles

Can't change cell color in Excel

May 31, 2005 at 10:06:31
Specs: Windows 2000, P4, 256 MB RAM

Within a specific Excel 2002 Spreadsheet that I have, I am unable to change the color/fill of specific cells. I can change the color/fill of cells in the 1st half of the sheet, but for some reason in the second half I am unable to change the color's. The cell's link to other cell's in another spreadsheet. Some cell's I can change, other's I cannot. The spreadsheet is not protected. I have tried to run a repair on this specific spreadsheet, however that has not helped. I have also tried opening the spreadsheet in Excel 2000, and still have not had any luck with being able to change the formatting.

Any idea's?

Jubee


See More: Cant change cell color in Excel

Report •


#1
May 31, 2005 at 11:12:24

What is meant by 'the second half of the sheet'?

Perhaps you have exceeded the "Cell formatting limitations of Excel but you did not mention any error messages.

Bryan


Report •

#2
May 31, 2005 at 11:17:45

It is not exactly just the second half of the sheet that the cell's are not working properly on. Basically the first 45 or so row's allow me to change the cell fill color, but then the remainder of cells in that sheet do not allow me to change their formatting. I highlight the cell I want to change, apply the color fill change, and nothing happens. All in all the sheet is about 80 row's in length.

I do not get any error messages.

Thanks

Jubee


Report •

Related Solutions


Ask Question