Close this search box.

Advanced Excel Training: Format Cell Fill Patterns and Gradients

Filling cells with vibrant colors is extremely easy to do, but Excel also has advanced options that allow you to use your Format Cell dialog box to pattern and shade these colors as well. This Excel tutorial will show you how to use these features to your advantage. You will learn Excel the easy way and be able to implement advanced coloring into your worksheets.

Before we can do anything, you will need to click on a single cell or highlight a group of cells that you wish to work in. Once this is done, you need to bring up the Format Cell dialog box. Go to the Home tab in your Excel toolbar. From there you will be able to find the Font box, which has a small downward-facing arrow in the bottom right-hand corner. Click on this and then click on the Fill tab in the new window:

Cell Fill Pattern

On the right hand-side of the Fill tab of the Format Cells dialog box, you have the option to choose a pattern color and style. Click on the arrow beside Pattern Color and choose the color you wish to use. Then click the arrow next to Pattern Style and choose the one that you will put into your worksheet. Finally, click OK and Excel will perform the task for you. Here is an example of what the different patterns will look like in action:

Cell Fill Gradient

Underneath the Background Color section of the Fill tab on the Format Cells dialog box, you will see a button that says Fill Effects… When you click on it, a new window will appear that looks like this:

You can choose two colors and merge them together, giving a stunning shading effect. At the top, click on the little arrow next to Color 1 and pick one. Then click on Color 2 and choose the next one. In the bottom right-hand corner under Sample, you can see an example of what you are creating.

Under Shading Styles, you can choose the style you want. It will show you what the option will do under Variants. There are six options available and once you have chosen one, click OK. It will take you back to the Format Cell dialog box where you can preview your choice at the bottom (under Sample). If you like the effect, then click OK on this window as well. Excel will automatically create gradients in your highlighted cells. Here are examples of what each option will look like:

If you wish to remove any of this formatting, simply click on the No Fill option on the Fill Color drop-down menu found in the Font box on the Home tab:

Now that you understand how to fill cells with colors, patterns and gradients; there is nothing stopping you from creating extremely professional-looking spreadsheets that will be the envy of all. After several students from our Excel training courses in South Florida recommended it, we have written this article to enlighten people about these unknown features. For more information on exactly how to use all the Excel functions to your advantage, please watch our Excel video tutorials.

Hector Garcia CPA and QuickBooks/Excel Trainer

Hector Garcia CPA and QuickBooks/Excel Trainer

Use our link to get 30% off for a year, valid through 07/31/2022

Popular Courses

Private QuickBooks Training onsite

Customized Training

Accounting & Bookkeeping Services

Video-Based Virtual QuickBooks Course


30% Off QuickBooks

Use our link to get 30% off for a year, valid through 07/31/2022