Fill colour is a popular formatting feature in Excel that allows you to highlight cells with a specific colour. However, there may be times when you want to remove fill colour from cells. This could be because you want to change the colour or remove formatting altogether etc. In this tutorial, we will learn how to remove Fill Color in Excel.
Here we have a dataset shown above related to medicines. In the first column, standard Fill Color is used and in the second column, Color Scaling is used using Conditional Formatting. Here we will see how to remove these background colours using the following methods but first let’s have a look at the dataset.
Method 1: Remove Fill Color.
Step 1 – Select the Data with Fill Color.
- Select the data with the fill colour.
- Open the drop-down menu of Fill Color in the Home tab.
Step 2 – Remove Fill Color
- After opening the Fill Color drop-down menu choose No Fill.
- All the cells with Fill Color will be removed.
Method 2: Remove Conditional Formatting.
Step 1 – Select the Data with Formatting.
- Select the data on which conditional formatting is applied.
- Go to Conditional Formatting in the Home tab.
- Open Clear Rules.
- Choose the suitable option.
Step 2 – Clear Rules
- Either select Clear Rules from Selected Cells or Clear Rules from Entire Sheet.
- In our case, we have some selected cells from which we have to remove fill colours therefore we selected Clear Rules from Selected Cells.
- Conditional formatting will be removed.