How to Shade a Cell in Excel With Two Colors

How-to basics · Updated November 20, 2026

Excel does not have a built-in cell-fill option that divides one cell into two solid-color halves. For a diagonal split, overlay two matching, opposite-facing triangle shapes on the cell. If you want two colors while keeping the cell’s contents visible, use a two-color pattern fill instead. The steps below are for Excel for Microsoft 365 on Windows.

What You’ll Need

  • A workbook open in Excel for Microsoft 365 on Windows.
  • The cell you want to shade. Decide whether you need a solid diagonal split or a pattern; the pattern method keeps cell text visible.
  • For the diagonal method, allow enough room to select and position shapes. You can zoom in with the zoom control at the bottom-right of the Excel window.

Step-by-Step

  1. Choose the two-color effect. Use a pattern fill if a hatch, dot, or other repeated design in two colors will work. It is an actual cell fill and will not cover text. Use triangle shapes if you want two clean, solid-color sections divided by a diagonal. Shapes sit above the worksheet, so they can cover the cell’s contents.
  2. Select the target cell. Click the cell you want to format. If you plan to use the diagonal shapes, first adjust the column width or row height to the size you want. The shapes will be easier to position before the cell contains important text or figures.
  3. For a two-color pattern, open the Fill settings. With the cell selected, press Ctrl+1 to open Format Cells. Choose the Fill tab. In the Pattern Style list, choose a pattern such as diagonal stripes, dots, or a grid. The choices are designs rather than two separate solid halves, so preview a few if you are unsure which will be easiest to read.
  4. Choose both pattern colors. In the Fill tab, set Background Color to the first color and Pattern Color to the second. The background is the base color; the pattern color appears in the design laid over it. If the preview looks too faint, choose more contrasting colors or a denser pattern. Click OK to apply the fill to the selected cell.
  5. For a diagonal split, insert a right triangle. Select the cell, then choose Insert > Shapes > Right Triangle. Draw the triangle over the cell, from one corner to the opposite corner. On Windows, hold Alt while drawing or resizing to help the shape snap to cell boundaries. Zooming in makes it easier to start and end on the exact corners.
  6. Set the first triangle’s color and remove its outline. Select the triangle. On the Shape Format tab, choose Shape Fill and select the first color. Choose Shape Outline > No Outline so a border does not make the dividing line look heavier than intended. If you do not see Shape Format, click the shape again to select it.
  7. Duplicate the triangle in place. With the triangle selected, press Ctrl+D. The duplicate should have the same size and position as the original. Select the duplicate, choose Shape Format > Rotate > Rotate 180°, and apply the second color using Shape Fill. The opposite-facing triangles should cover complementary halves of the cell.
  8. Check the edge and alignment. Click away from the shapes and inspect the result. If a sliver of the worksheet shows at an edge, select the relevant shape and adjust it slightly so it meets the cell boundary. If the two halves appear to overlap incorrectly, confirm that the second triangle is rotated 180 degrees and that both shapes have the same dimensions and position.
  9. Save and verify the result. Save the workbook. If the colors need to appear on paper or in a PDF, open Print Preview and check the cell there too. A pattern fill belongs to the cell; the diagonal version is made of shapes, so verify the shapes remain in place when you resize rows or columns.

Common Mistakes

Expecting a native split-fill setting: The ordinary cell Fill Color button applies one solid color. Format Cells also offers pattern fills, but it does not provide a control for a clean diagonal division into two solid halves. Use paired shapes for that effect.

Using two shapes with different sizes: If the duplicated triangle is resized, the diagonal may not meet the cell’s corners or the halves may leave a gap. Duplicate the first triangle before rotating it, and avoid resizing the copy independently.

Forgetting the outline: A triangle’s default outline can form a visible border around the cell or a dark seam along the diagonal. Set Shape Outline to No Outline on both triangles.

Covering cell contents: Opaque shapes are drawn over the worksheet grid and can hide text or values. Use the pattern-fill approach when the cell must remain readable and editable. A shape-based split is most suitable for decorative cells or a layout where the text is placed separately.

Assuming shapes are part of the cell: Shapes float over the grid. They may not follow a row or column change the way a cell fill does unless their properties are configured accordingly.

Tips

Pick colors with enough contrast to distinguish the two areas, but consider how they look alongside nearby cells. A very dark shade next to small text may reduce readability. For a pattern fill, test the design at the worksheet’s normal zoom and in print preview; a fine pattern that looks clear on screen can print as a dense patch.

For a shape-based split, make the target row and column the right size before drawing. When a shape is selected, you can open its formatting options and use the size and position controls for more precise adjustments. In the Format Shape pane, look under Size & Properties for positioning and object properties. Depending on the Excel build, the pane’s layout can vary slightly.

If you want the shapes to stay with the cell as the sheet changes, select each shape, open Format Shape, and find Size & Properties. Under Properties, choose Move and size with cells. Check the result after changing the row height or column width. This behavior is useful for a designed worksheet, but it does not turn the shapes into a real cell fill.

Use a pattern fill when you need sorting, copying, or editing to behave normally at the cell level. Use the triangle approach when the visual split matters more than having one simple cell-formatting property. You can copy a pattern-filled cell with Format Painter or regular copy and paste. To reuse the shape effect, select both triangles together and copy them as a pair.

Troubleshooting

The colors do not look like two solid halves: You probably chose a pattern in Format Cells. That is the built-in two-color fill option, but it repeats a design across the cell. For a single diagonal division, switch to the two-triangle method.

The second triangle hides the first: Check that the two triangles are the same size and occupy the same cell. A right triangle rotated 180 degrees should cover the other half. If the second shape is a different type, delete it and duplicate the original instead.

A white line or gap appears between the halves: Make sure both shapes meet at the same diagonal and neither has an outline. Zoom in and check that their edges touch; if necessary, nudge a shape slightly. Also confirm that both shapes cover the cell’s full width and height.

The shapes move when you change the sheet: Select each shape and set its property to Move and size with cells in the Format Shape pane. If you need a stable printed layout, avoid changing the underlying row height or column width after positioning the shapes, or inspect and realign them afterward.

You cannot select a shape because it is behind another object: Click an exposed part of the shape, or use Home > Find & Select > Selection Pane to locate and select the objects. The Selection Pane is especially helpful if several shapes overlap or if a shape is difficult to click.

The pattern looks different on another computer: Confirm that the workbook was saved and reopened in Excel, and check the Fill tab settings again. If the appearance must be identical in a handout, export or print a test page and review the output before sharing it.

Frequently Asked Questions

Can Excel fill half a cell with one color and half with another?
Not with the standard cell-fill controls. Use two complementary triangle shapes for a solid diagonal split, or choose a pattern fill for two colors in a repeated design.

Can I split a cell vertically or horizontally instead of diagonally?
Excel does not offer a native split-cell fill for those divisions either. You can use two rectangle shapes, each covering half the cell, and give each a different fill. For text that must remain visible, consider using a pattern or separate neighboring cells instead.

Will the triangle method keep the cell’s text visible?
Not if the shapes are opaque and cover the text. Use a pattern fill to keep text in the cell visible. If the design requires a diagonal split, put the label in a separate text box or another cell and check its alignment after editing the sheet.

Can I use a two-color pattern and still type in the cell?
Yes. A pattern fill is cell formatting, so you can enter, edit, and format the cell’s value normally. Choose a pattern and colors that leave enough contrast for the text.

Do the steps differ on a Mac or in Excel for the web?
The Fill tab and Format Cells options are available in desktop Excel for Mac, though the ribbon and dialog layout can differ; use the Format Cells dialog to set the pattern and its colors. Shape insertion and rotation are also available, but snapping and shortcut behavior may differ from Windows. Excel for the web has more limited shape-formatting controls, so use desktop Excel for the precise triangle method.

Will the two-color formatting print?
Cell pattern fills normally print with the worksheet. Shapes normally print too, but they are separate objects and can be positioned incorrectly after layout changes. Check Print Preview before distributing the sheet.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.