Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

This question already has an answer here:

6/15/2012 I'm having the same problem as a previous user's query (linked below) wherein I can't change the font or cell shading color on an Excel spreadsheet. I've confirmed that the cell/spreadsheet is NOT locked and have checked the conditional formatting function to make sure it is not affecting the worksheet. However, the problem remains. As a further clue, when I select "more colors" from the cell shading or font drop-down arrow the dialog box shows that the "current" color is the one I have selected for the cell, but the cell is not reflecting that color. Is it possible that my Excel has been corrupted or am I just too obtuse to figure it out? Any help will be GREATLY appreciated.

In excel, cannot figure out why background color for a cell will not change?

share|improve this question

marked as duplicate by slhck Nov 6 at 17:52

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

1  
Your scenario of inheriting an Excel document that won't change colors may be the same as the other question, but his was a conditional formatting issue (as indicated by part of his question and the accepted answer) and you have stated that you already verified that it's not conditional formatting on your sheet. Having said that, are there any formulas in that cell or VBA in the sheet that could be reverting the colors? –  techturtle Jun 15 '12 at 17:11

1 Answer 1

How did you check conditional formatting? Just in case it is. This worked for me

1: Highlight the cells containing the fill color that you have previously been unable to remove. Highlight your conditionally formatted cells

2: Click the “Home” tab at the top of the window.

3: Click the “Conditional Formatting” drop-down menu in the “Styles” section of the ribbon. Open the conditional formatting menu

4: Click the “Clear Rules” option at the bottom of the menu, then click the “Clear Rules From Selected Cells” option. Note that, if you have a lot of different cells or groups of cells in your spreadsheet, and don’t need to leave any of the conditional formatting in place, you could click the “Clear Rules From Entire Sheet” option instead. Clear conditional formatting from your selected cells

share|improve this answer

protected by Community Nov 6 at 17:52

Thank you for your interest in this question. Because it has attracted low-quality answers, posting an answer now requires 10 reputation on this site.

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged or ask your own question.