Excel, Can’t Remove Cell Fill Color
If you have an Excel workbook with cells that have a fill color that can’t be removed, there are 2 possible reasons for this.
Reason #1, Conditional Formatting:
Conditional formatting might have been applied to the cell or range. Conditional formatting will create a fill effect for the cells it is applied to . In order to remove the conditional formatting:
- Click on the Home Ribbon
- Click on the Conditional Formatting button
- From the drop down menu click on Clear Rules
- Select either “Clear Rules From Selected Cells” or “Clear Rules From Entire Sheet”
Reason #2, VBA Code:
Another reason that you may not be able to remove the fill color from cells is a possible VBA Macro that is generating the fill colors. In order to prevent this:
Step 1: Bring the developer ribbon if it not already available.
Step 2: Click on the Visual Basics button:
Step 3: In the window that opens click on one of the objects on the left:
Step 5: The code that changes cell fill colors, will be something like the example codes below:
Range("A1").Interior.Color = 46545
Range(Cells(1, 1), Cells(2, 3)).Interior.Color = 45446
sheet2.Range("B2:D3").Interior.Color = vbRed
As you can see they all have the text
. So basically we want to search the entire project for the term .Interior.Color
and remove it:.Interior.Color
If you need assistance with your code, or you are looking for a VBA programmer to hire feel free to contact me. Also please visit my website www.software-solutions-online.com
4 thoughts on “Excel, Can’t Remove Cell Fill Color”