How to add a background color to a range

To add a background color to a selected range

1. First, select the range you want to apply a background color to (see diagram below)

2. Next, click the down arrow next to the ‘Fill Color’ Command. If you want to use the default Fill Color – then there is no need to click the down arrow next to it, just click the Fill Color command itself and Excel will apply the default Color to your selected range.

3. You will be presented with 3 color options:

A. Theme Colors – You can click a theme color to apply to your select range, and Excel will apply the color for you.

B. Standard Colors – If you choose, you can apply a Standard Color to your selected range, and Excel will apply the color you chose for you.

 

how to add a background color to a range

 

Tip: To remove a background color from a selected range, click the ‘No Fill’ command. See the diagram above for to see where the ‘No Fill’ command is located.

 

C. Custom Colors – Or you can choose to create a Custom Color to apply to your selected range.

 

4. If you want to apply a custom color – Click on the more colors button (see the diagram above)

A Color dialog box will appear with Standard and Custom Color options

To choose a Standard color (see the diagram below)

how to add a background color to a range 2

 

5. Click any color on the Hexagon Color chart presented to you and then click the OK button.

Or you can Click the ‘Custom’ tab and click the color you want (see the diagram below)

how to add a background color to a range 3

 

6. Then use the control to set a customized color (as seen in the diagram below)

how to add a background color to a range 4

 

7. After that, Click the OK button

how to add a background color to a range 5

 

Excel will apply the color effects for you

Lesson 35: How to apply a Number Format

Submit a Comment

Your email address will not be published. Required fields are marked *