One of the best ways to improve the appearance of a worksheet in Excel 2010 is through the use of cell fill colors. They provide a nice break from the monotony of black text on a white background, while also creating another method of organization. In fact, you could easily employ a method of filling cells that meet a certain criteria to help yourself and anyone else that is viewing your worksheet. But sometimes you need to change the fill color of a cell that already has one, so you will need to learn how to change a cell fill color in Excel 2010.
***If following the steps in this article to change a cell’s fill color does not work, then your worksheet probably has some conditional formatting. You can follow the instructions in this article to remove the conditional formatting and then change the fill color using the method outlined below.***
Use a Different Cell Fill Color in Excel 2010
The method for changing a cell’s fill color is actually very similar to the method that was used to fill the cell in the first place. But if you have received a worksheet from someone else and have never used the Fill Color tool before, then this tutorial is for you.
Step 1: Open the Excel file in Excel 2010.
Step 2: Click the tab at the bottom of the window for the worksheet containing the cell whose fill color you wish to change.
Step 3: Use your mouse to select the cell or group of cells that contain the fill color you wish to change.
Step 4: Click the Home tab at the top of the window.
Step 5: Click the Fill Color drop-down menu in the Font section of the ribbon at the top of the window, then choose the fill color that you want to use. If you do not want to have any cell fill color, choose the No Fill option.
If, after changing the fill color, you decide that you preferred the old one, you can press Ctrl + Z on your keyboard to undo the change.