How to Fill Half a Cell in Excel with Color Using Shapes

How-to basics · Updated November 20, 2026

Excel does not have a built-in setting that fills exactly half of a cell with a solid color. To create the effect, fill the cell with one color, then place a colored shape—usually a right triangle—over half of it. This works for diagonal splits; a rectangle shape can make a horizontal or vertical split.

What You’ll Need

  • Excel for Microsoft 365 on Windows, or the desktop version of Excel for Mac. The ribbon names below are for Windows; Mac differences are noted where they matter.
  • A worksheet with the target cell sized approximately as you want it to appear. You can resize the row or column later, but the shape may need adjusting.
  • The two colors you want to use. One will be the cell’s background fill, and the other will be the shape’s fill.

Step-by-Step

  1. Choose and size the cell. Click the cell you want to split visually. Adjust its row height or column width first if the default cell is too small to show the effect clearly. Use Home > Format to access row-height and column-width options, or drag the row or column boundary. A square or rectangular cell both work; the diagonal will follow the triangle’s shape, not necessarily divide the area into two equal-looking regions if the cell is very wide or tall.
  2. Set the first color as the cell background. With the cell selected, go to Home > Fill Color, the paint-bucket button in the Font group, and choose the color for the part that will remain uncovered. If you do not see the exact color, choose More Colors. This fills the entire cell for now; the shape added in a later step will cover part of it with the second color.
  3. Insert a right triangle. Select Insert > Shapes > Right Triangle. The pointer changes to a crosshair. Click and drag on the worksheet to draw a triangle roughly over the target cell. Do not worry if it is not exact yet. Drawing the shape near the cell first can make it easier to see its orientation and resize it accurately.
  4. Choose the triangle’s orientation. A right triangle has one vertical side, one horizontal side, and a diagonal side. Drag the shape’s handles so its outer edges line up with three edges of the cell and its diagonal runs across the cell. If the right angle is in the wrong corner, select the shape and use Shape Format > Rotate, or right-click it and choose Rotate. The exact rotation or flip option available can depend on the selected shape and Excel version. Check the diagonal before proceeding; the two colored areas should meet along that edge.
  5. Set the triangle’s size and position. With the shape selected, drag its corner handles until it covers one half of the cell. For a diagonal split from one corner to the opposite corner, align the triangle’s vertical and horizontal sides with the corresponding cell edges. Zoom in if the borders are difficult to line up. Hold Alt while dragging or resizing on Windows to help snap the shape edges to cell boundaries; on Mac, use the alignment guides and zoom in, as the same snapping behavior may differ.
  6. Fill the triangle with the second color. Select Shape Format > Shape Fill and pick the other color. Then select Shape Format > Shape Outline > No Outline to remove the triangle’s border. Without this setting, a thin outline can show across the diagonal or around the cell and make the split look uneven. If you want a visible dividing line, keep an outline and choose a line color deliberately instead.
  7. Fine-tune the fit. Zoom to 150% or more using the zoom control at the bottom of the Excel window, then adjust the shape edges. The shape should cover the intended half without extending into neighboring cells. If it is slightly off, click the shape and use the arrow keys to nudge it; on Windows, pressing an arrow key moves a selected shape a small amount. Return to normal zoom to check how the result looks in the sheet.
  8. Make the shape follow the cell when practical. Right-click the triangle and choose Format Shape. In the Format Shape pane, open Size & Properties, then Properties, and select Move and size with cells. This helps the shape stay associated with the cell when you change row height or column width. It does not make the shape part of the cell itself, so verify the alignment after resizing, filtering, sorting, or moving worksheet content.
  9. Save and check the finished cell. Click a blank area to deselect the shape. Confirm that the two colors meet cleanly, the shape has no unwanted outline, and neighboring cells are untouched. Save the workbook. If the shape covers text in the cell, see the text options in Tips before relying on the result in a report.

For a horizontal or vertical split: Use the same method, but insert a rectangle from Insert > Shapes > Rectangle instead of a triangle. Set the cell’s background to one color, draw the rectangle over the top or bottom half (or the left or right half), and apply the second fill with no outline. A rectangle is easier to align for straight horizontal or vertical divisions; the triangle is the useful choice for a diagonal division.

Common Mistakes

  • Looking for a half-fill option in the cell formatting dialog. Excel’s regular Fill Color setting colors the whole cell. A diagonal border does not divide the fill into two colors either. The split-color appearance comes from placing a drawing shape over the cell.
  • Using the wrong triangle orientation. A right triangle may initially point in a direction that covers the wrong corner. Rotate or flip it and inspect the diagonal rather than assuming the first orientation is correct.
  • Leaving a shape outline turned on. The default outline can create a dark seam or a border that sticks outside the cell. Set Shape Outline to No Outline unless you intentionally want a line.
  • Resizing the cell after positioning the shape. A shape can move or scale with cells when configured to do so, but the visual fit may still need checking. Row height changes, column-width changes, and zoom can make small alignment errors more noticeable.
  • Expecting the cell fill to remain editable as two parts. Only the background color is a cell fill; the second color belongs to a separate shape object. Selecting the cell and changing its fill will not change the shape’s fill.
  • Covering a cell value or formula with an opaque shape. Shapes sit above worksheet cells and can hide their contents. A colored shape is not a reliable way to keep visible text in the same cell unless you add separate text boxes or use another layout.

Tips

  • Use a simple color pair. Choose colors with enough contrast to make the boundary easy to read, but avoid combinations that make labels hard to see. Consider how the colors look when printed in grayscale or viewed by someone with color-vision differences.
  • Use the cell fill for the larger or background area. It is simpler to set the base color once and use one shape for the contrasting region than to stack several shapes. For a diagonal split, one triangle over a solid cell background is usually sufficient.
  • Keep the drawing object manageable. If you have many cells to mark, copying and pasting a finished shape can save time. After pasting, check its location and size: Excel may place a duplicate offset from the original, and a copied shape can cover the wrong cell.
  • Plan around text. An opaque triangle or rectangle hides anything beneath it, including a value. For labels in both colored regions, leave the cell itself blank and add separate text boxes positioned over the two halves. Text boxes are also shapes, so check their alignment if cells are resized. For ordinary data tables, consider using two adjacent cells instead; that keeps values selectable and easier to sort or filter.
  • Consider the workbook’s purpose. Shapes are useful for a visual schedule, legend, or one-off diagram. They are less suitable for a large data table that people will sort, filter, copy, or update often. If the color represents a status or category, a text label, symbol, or pair of cells may communicate the information more robustly.
  • Remember that web and Mac controls vary. Excel for the web supports many basic shape operations, but its shape-formatting and alignment options can differ from desktop Excel. For precise placement and the Move and size with cells setting, use the Windows or Mac desktop app. On Mac, the Shape Format tab appears when a shape is selected, though some commands may be arranged differently from the Windows ribbon.

Troubleshooting

The shape will not sit exactly on the cell. Increase the worksheet zoom, drag the shape from its edge rather than its middle, and adjust the corner handles separately. On Windows, try holding Alt as you drag to snap to cell boundaries. If the row or column is unusually narrow, widen it temporarily, place the shape, then restore the size and inspect the result.

The colored area is on the wrong side of the diagonal. Select the triangle and use Shape Format > Rotate or the rotate handle to change its direction. If the diagonal is correct but the filled region is on the opposite side, use a different triangle orientation or flip the shape. You can also swap which color is the cell background and which is the shape fill.

A line remains visible after removing the outline. Confirm the triangle is selected, not the cell, and choose Shape Format > Shape Outline > No Outline. If a line still appears, it may be the cell’s border or worksheet gridlines rather than the shape outline. Check Home > Borders for the cell, and remember that gridlines are display guides rather than printed cell borders.

The shape shifts when the sheet changes. Right-click it, open Format Shape, and check Size & Properties > Properties. Move and size with cells is useful when the cell changes dimensions, but the shape is still a separate object. Recheck it after sorting or filtering; for a visual that must remain tied to records as they move, use a table layout with separate cells instead.

The cell’s text disappears. The shape is covering the cell content. Move or delete the shape to confirm. If you need visible text in both halves, use text boxes placed above the shapes, or redesign the layout with adjacent cells so each area can hold its own text.

The option names do not match. Make sure you are in the desktop version of Excel and that the shape—not the cell—is selected. Shape Format is a contextual tab, so it appears only after selecting a shape. In Excel for the web or on Mac, formatting controls may be arranged differently; look for Shape Fill, Shape Outline, rotation, and the shape’s properties in the format pane.

Frequently Asked Questions

Can Excel fill half a cell with color without using a shape?
No. Excel’s standard cell fill colors the whole cell. A shape overlay is the practical way to create a solid half-color effect inside one cell.

Can I split a cell diagonally into two colors?
Yes. Set one color as the cell fill, then cover the desired triangle-shaped half with a right-triangle shape filled with the second color. Remove its outline for a clean diagonal.

Can I make the split exactly horizontal or vertical?
Yes. Use a rectangle shape over half the cell instead of a triangle. Align its edges with the cell boundaries and use the cell fill for the uncovered area.

Will the shape stay in place if I change the cell size?
It can move and size with the cell if you set Format Shape > Size & Properties > Properties > Move and size with cells. Still, inspect the alignment after changes, especially after sorting, filtering, or moving rows.

Can I type text in both colored halves?
Not as two independent cell values. A cell holds one value, and an opaque shape can hide it. Use separate text boxes for a visual label, or use adjacent cells if the information needs to be edited, sorted, or filtered.

Does this method work in Excel for Mac?
Yes, the basic shape-overlay approach is available in desktop Excel for Mac. The ribbon layout and snapping behavior can differ, so use the alignment guides, zoom in, and check the Format Shape pane for the relevant options.

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.