How to Fill an Excel Cell With Two Colors

Fill colors in Excel 2010 and 2013 usually fill each cell with a single solid color, no matter how large the cell in question. To add two background colors to one cell, use the Two Colors fill effect to create a gradient.

Step

Select the cell you want to fill, right-click the cell and choose Format Cells.

Format Cells in context menu
credit: Image courtesy of Microsoft

Step

Open the Fill tab and click Fill Effects.

You can't combine a two-color effect with a pattern, so leave the Pattern Style blank.
You can't combine a two-color effect with a pattern, so leave the Pattern Style blank.
credit: Image courtesy of Microsoft

Step

Choose Two Colors, and then pick the two colors you want to use with the Color 1 and Color 2 selectors.

Click More Colors and then Custom for a full RGB color picker.
Click More Colors and then Custom for a full RGB color picker.
credit: Image courtesy of Microsoft

Step

Pick a shading style and choose one of the variants.

Picking a style and variant
credit: Image courtesy of Microsoft

Step

Click OK on both open windows to set the new fill colors.

A Vertical style applied across several rows and columns.
A Vertical style applied across several rows and columns.
credit: Image courtesy of Microsoft