Computing.Net > Forums > Office Software > Can't change cell color in Excel

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Can't change cell color in Excel

Reply to Message Icon

Name: weinstein
Date: May 31, 2005 at 10:06:31 Pacific
OS: Windows 2000
CPU/Ram: P4, 256 MB RAM
Comment:

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



Sponsored Link
Ads by Google

Response Number 1
Name: Bryco
Date: May 31, 2005 at 11:12:24 Pacific
Reply:

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


0

Response Number 2
Name: weinstein
Date: May 31, 2005 at 11:17:45 Pacific
Reply:

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


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links

Ads by Google


Results for: Can't change cell color in Excel

Change cell color in Excel www.computing.net/answers/office/change-cell-color-in-excel/9540.html

colors in excel vba www.computing.net/answers/office/colors-in-excel-vba/6989.html

Can't change pattern color in cells www.computing.net/answers/office/cant-change-pattern-color-in-cells/9643.html