How to Fill an Excel Cell With Two Colors
Each cell in your spreadsheet usually has a single color, but by adding a gradient, you can use two colors in one cell.
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.
Looking to use two text colors for a cell's contents instead? Select the cell, press F2, select the individual characters you want to recolor and choose a font color.
Select the cell you want to fill, right-click the cell and choose Format Cells.
Optionally, select multiple cells to fill with the same two-color gradient.
Open the Fill tab and click Fill Effects.
Choose Two Colors, and then pick the two colors you want to use with the Color 1 and Color 2 selectors.
Pick a shading style and choose one of the variants.
- Gradient colors apply separately to each cell, so some styles won't flow well when applied to several cells. Use a Horizontal style on multiplerows, for example, and the horizontal color bars repeat on each row. For a smooth gradient across cells, use Vertical for coloring multiple rows and Horizontal for coloring multiple columns.
- Other styles, such as From Center, do not flow between cells at all, and so are best used for single-cell coloring.
Click OK on both open windows to set the new fill colors.
When you fill several cells, the colors cover up the spreadsheet's gridlines. To show lines atop the colors, select the colored cells, open the Borders drop-down menu and choose All Borders.