Have you ever wanted to highlight important data in Excel or make your worksheet easier to read?
You can do this by changing the background colour of cells using the Fill Color option.
For example, you can add a background colour to column headings, highlight important values, or use different colours to organise your data.
In this article, let’s learn how to use Fill Color in Excel with simple examples.
What Is Fill Color in Excel?
Fill Color is an Excel formatting option that lets you change the background colour of a cell or a range of cells.
You can use it to highlight important information, make headings stand out, and improve the appearance of your worksheet.
For example, you can apply a light blue colour to column headings and a light yellow colour to important values.
Remember: Fill Color changes the cell background, not the text colour. To change the text colour, use the Font Color option.
How to Apply Fill Color in Excel?
You can apply a background colour to a cell or a range of cells using the Fill Color option on the Home tab.
Follow these steps:
1. Select the cell or range of cells you want to colour.
2. Go to the Home tab on the Ribbon.
3. In the Font group, click the drop-down arrow next to Fill Color.
4. Choose the colour you want to apply.
Excel applies the selected colour to the cells.
Example: Apply Fill Color to Column Headings
Suppose you have the following data:
| Employee | Department | Region | Sales |
| Ravi | Sales | East | 25000 |
| Priya | Marketing | West | 30000 |
| Kiran | Finance | South | 20000 |
If you want to highlight the column headings:
1. Select the heading cells A1:D1.
2. Go to the Home tab.
3. Click the arrow next to Fill Color.
4. Select a light blue colour.
Excel applies the background colour to all the selected heading cells.
How to Change the Fill Color in Excel?
Suppose you have already applied a background colour to a cell but want to change it.
You don’t need to remove the existing colour first.
1. Select the cell or range of cells.
2. Click the drop-down arrow next to Fill Color.
3. Choose a different colour.
Excel replaces the existing background colour with the new colour.
How to Apply the Same Fill Color to Other Cells?
If you want to apply the same background colour to different cells, you can use the Format Painter.
Follow these steps:
1. Select a cell that already has the fill colour you want.
2. Go to the Home tab.
3. Click Format Painter in the Clipboard group.
4. Select the cells where you want to apply the same formatting.
Excel copies the formatting, including the fill colour, to the selected cells.
How to Apply a Custom Fill Color in Excel?
Excel provides Theme Colors and Standard Colors, but sometimes you may want to use a specific colour.
For example, you may want to use the same colour as your company logo or report design.
You can use the More Colors option to choose a custom colour.
1. Select the cell or range of cells.
2. Go to the Home tab.
3. Click the arrow next to Fill Color.
4. Select More Colors.
5. Choose the colour you want from the colour dialog box.
6. Click OK.
Excel applies the selected custom colour to your cells.
How to Remove Fill Color in Excel?
If you no longer need a background colour, you can remove it without deleting the data.
Follow these steps:
1. Select the cells from which you want to remove the fill colour.
2. Go to the Home tab.
3. Click the arrow next to Fill Color.
4. Select No Fill or white color.
Excel removes the background colour from the selected cells.
Your data remains unchanged.
How to Apply Fill Color Using the Format Cells Dialog Box?
You can also change the background colour using the Format Cells dialog box.
Follow these steps:
1. Select the cell or range of cells.
2. Press Ctrl + 1 to open the Format Cells dialog box.
3. Go to the Fill tab.
4. Choose the background colour you want.
5. Click OK.
Excel applies the selected fill colour to the cells.
You can also use this dialog box to apply patterns and pattern colours to cells.
Fill Color vs Font Color in Excel:
Both Fill Color and Font Color are available in the Font group on the Home tab, but they do different jobs.
| Fill Color | Font Color |
| Changes the background colour of a cell | Changes the colour of the text |
| Used to highlight cells | Used to make text stand out |
| Represented by a paint bucket icon | Represented by an A with a coloured underline |
For example, you can apply a yellow Fill Color to a cell and change its Font Color to dark blue.
Fill Color vs. Conditional Formatting in Excel:
Fill Color and Conditional Formatting both help you highlight cells, but they work differently.
| Feature | Fill Color | Conditional Formatting |
| Purpose | Applies a background color manually | Applies formatting based on rules |
| How it works | You choose the color | Excel checks the specified conditions |
| Automatic updates | No, not based on cell values | Yes, when the conditions are reevaluated |
| Example | Highlight a heading in blue | Highlight sales below the target in red |
For example, if you want to highlight a heading row, Fill Color is sufficient.
But if you want Excel to highlight sales figures below ₹30,000 automatically, Conditional Formatting is more suitable.
Common Mistakes When Using Fill Color:
Here are a few things to remember when using Fill Color in Excel.
- Selecting the wrong cells: Make sure you select the correct cells before applying a fill colour.
- Using Font Color instead of Fill Color: Font Color changes the text colour, while Fill Color changes the cell background.
- Choosing very dark colours: Dark background colours can make the text difficult to read. Choose colours that provide good contrast.
- Colour not appearing when printing: Check whether the Black and white or Draft quality options are enabled in the Page Setup settings.
Frequently Asked Questions:
1. Where is the Fill Color option in Excel?
The Fill Color option is available in the Font group on the Home tab.
2. What is the keyboard shortcut for Fill Color in Excel?
On Windows, press Alt + H, H to open the Fill Color menu. You can then use the arrow keys to choose a colour.
3. Can I apply Fill Color to multiple cells at once?
Yes. Select the cells you want to colour, open the Fill Color menu, and choose a colour. Excel applies it to all selected cells.
4. Does Fill Color change the original data?
No. Fill Color only changes the background colour of cells. It does not change the values or formulas.
5. How do I remove the background colour without deleting the data?
Select the cells, go to Home → Fill Color → No Fill. Excel removes the background colour while keeping the data unchanged.
6. Can I use my own colour in Excel?
Yes. Click the arrow next to Fill Color, select More Colors, choose your preferred colour, and click OK.
Final Thoughts:
The Fill Color option in Excel is a simple way to highlight important information and make your worksheet easier to read.
You can use it to highlight headings, important values, or specific cells. You can also change or remove the background colour whenever you need.
Try using different colours in your worksheet and see how they improve the appearance of your data!
Discover more from Excellopedia
Subscribe to get the latest posts sent to your email.