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.
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)
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)
6. Then use the control to set a customized color (as seen in the diagram below)
7. After that, Click the OK button
Excel will apply the color effects for you
Lesson 35: How to apply a Number Format