How to Fill an Excel Cell With Two Colors

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.

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 1: Format Cells

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

Advertisement

Video of the Day

Image Credit: Image courtesy of Microsoft

Step 2: Open Fill Effects

Open the Fill tab and click Fill Effects.

Advertisement

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

Step 3: Pick the Two Colors

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

Advertisement

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

Step 4: Pick a Style

Pick a shading style and choose one of the variants.

Advertisement

Advertisement

Image Credit: Image courtesy of Microsoft

Step 5: Apply the Colors

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

Advertisement

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

Advertisement

Advertisement

Video of the Day

references