Excel cannot split one cell into two independently coloured halves using a built-in cell-fill setting. To show two colours in a single cell, the practical workaround is to overlay two coloured shapes; if you only need separate coloured areas in a table, use two adjacent cells instead.
What “split cell colour” means in Excel
People asking how to split a cell’s colour usually want a diagonal header: one triangle in one colour and the other triangle in another, often with labels such as “Month” and “Product.” Excel cells do have fill colours, borders and text alignment, but a cell has one fill setting at a time. There is no Excel command that divides the cell into two independently formatted regions.
This is different from splitting the cell’s contents. The Text to Columns command separates text into multiple columns, while Merge & Center combines cells. Neither creates two coloured portions inside one cell. Excel also has no equivalent to Word’s table-cell split command. A diagonal border can draw a line across a cell, but it does not give each side its own fill colour.
That distinction matters because a visual effect made with shapes is not a change to the underlying cell structure. The cell remains one cell, with one value and one fill. The shapes sit over it as separate drawing objects.
Make a two-colour cell with shapes
In Microsoft Excel for Microsoft 365 on Windows, use two triangular shapes to cover the cell’s area. This works best for a small number of decorative headers. First set the target cell’s width and the row’s height, because changing either later can make the overlay misalign.
- Select the cell and set its ordinary fill to the colour you want for the background or for any small area not covered by a shape.
- Choose Insert > Shapes > Right Triangle, then drag a triangle over one half of the cell. Use Shape Format > Shape Fill to choose its colour and Shape Format > Shape Outline > No Outline to remove the edge.
- Insert a second right triangle and position it over the remaining half. Rotate or flip the triangles with the controls in Shape Format > Rotate until their diagonal edges meet in the direction you want. Set the second shape’s fill to the other colour and remove its outline.
- Adjust the shape size and placement so the two triangles cover the cell without gaps or overlap. For numerical placement, select a shape and use the Height and Width boxes on the Shape Format tab; visual fine-tuning may still be needed.
- To make the shapes follow the grid when the worksheet changes, right-click each shape, choose Format Shape, open Size & Properties, then Properties, and select Move and size with cells. Check the result after resizing rows or columns.
Right triangles have a fixed right angle, so their default orientation may not match the diagonal you want. Rotating or flipping each triangle is normal. Zooming in can help align the edges; at 100% zoom, a thin seam may be easier to spot. Keep the worksheet gridlines visible while positioning, then check the result at the zoom level readers will use.
Add labels to a diagonal header
Two colours alone may not explain what each half represents. A common example is a schedule header where one corner identifies the row category, such as “Employee,” and the other identifies the column category, such as “Week.” A shape does not automatically create a separate text area inside a cell, so labels need extra care.
One option is to add text boxes over the coloured triangles. Choose Insert > Text Box, draw a box over each half, type a short label, and set the text box fill and outline to No Fill and No Outline. Move each label into its corner and adjust its font size. Text boxes provide more control than forcing a long label into a narrow cell, but they are also extra objects that need to be kept aligned.
For a simple header, you can instead type both labels into the cell with a line break, then use alignment, indentation and wrapping to position the text approximately. This is less precise: the cell still has only one text alignment setting, so one label may not sit neatly in each triangle. Avoid inserting long strings of spaces to position text; the result can change with font, column width or printer settings.
Diagonal headers can also be harder to read than ordinary headings, especially on small screens or in printed tables. Use short labels, sufficient contrast, and a nearby explanation if the relationship between row and column headings is not obvious.
When adjacent cells are the better choice
If the goal is genuinely to show two pieces of information with different colours, separate cells are usually more reliable than a simulated split. For example, put “Sales” in one cell and “Quarter” in the next, colour each cell independently, and use borders to make them look like a single header area. This keeps the two labels selectable and editable as ordinary worksheet content.
Adjacent cells are particularly useful when the table will be sorted, filtered, resized, copied, or read by assistive technology. A shape overlay may look like part of a cell, but it is a floating object. It can cover text, be selected instead of the cell, or drift away from the intended location if its properties or the worksheet layout are changed.
For data tables, use clear column headings in separate cells rather than diagonal labels where possible. A flat header row with one field name per column is easier to filter and understand. If the visual design requires a diagonal header, keep the actual field names in a clear, structured header row and treat the diagonal graphic as decoration.
Other ways to show two colours
- Use a single fill and a diagonal border. Select the cell, open the Format Cells dialog, choose the Border tab, and apply a diagonal border. This draws a dividing line but leaves both sides the same fill colour.
- Use two neighbouring cells. This is the most dependable option for separate values or colour-coded categories. Adjust borders and column widths to create a unified visual block.
- Use conditional formatting for whole-cell rules. Home > Conditional Formatting can apply fills based on values or rules, but ordinary conditional formatting colours the cell as a whole; it does not fill one triangle differently from the other.
- Use a picture for a fixed design. A prepared two-colour graphic can be placed over a cell, but it is less convenient to edit and may not scale cleanly. For a worksheet that changes regularly, shapes or separate cells are usually easier to maintain.
- Use a chart or other visual object when the colours encode data. If the colours represent categories or proportions, a chart, legend, or separate formatted cells can communicate that meaning more clearly than a decorative split header.
A gradient fill is not the same as a split fill. A gradient transitions between colours, while a split-cell design has a sharp boundary. Even where a gradient is available for a drawing object, it does not create two independently editable cell regions.
Keep the design aligned and usable
Shapes are not stored as cell formatting. They may move, resize, or overlap other content depending on their placement and the cell properties selected. After adding shapes, test realistic changes: widen the column, increase the row height, hide and unhide the row, and print or export the sheet if those actions matter to your workflow.
To select an overlay that is difficult to click, use the Selection Pane from the Home tab’s Find & Select menu. The pane lists drawing objects so you can select, rename, hide, or delete the intended shape. Giving objects meaningful names is helpful when a worksheet contains many overlays. To remove one, select it and press Delete; take care not to delete the cell’s contents instead.
Consider contrast as well as appearance. Text should remain readable against its background, and colour should not be the only signal that distinguishes categories. Add clear labels or patterns where appropriate. A two-colour header can be attractive, but colour combinations that look distinct on one display may be difficult for some readers to distinguish or may print differently.
Desktop Excel provides the most direct controls for sizing and positioning these objects. The Mac ribbon may arrange shape-formatting controls differently, and Excel for the web may offer a different editing experience. If precise alignment is important, use desktop Excel and check the finished workbook in the environment where it will be viewed.
Common problems and fixes
- A white line appears between the triangles: Remove both shape outlines, zoom in, and adjust the objects so their diagonal edges meet. A thin gap can also reveal the cell’s underlying fill.
- The colours move when the table is resized: Check each shape’s Format Shape > Size & Properties > Properties setting. Move and size with cells is generally appropriate for an overlay that should track a cell, though you should still verify the layout after resizing.
- A shape covers a label or value: Move or resize the shape, or adjust the text box and its order. Shapes and text boxes are separate objects, so their stacking order affects what is visible.
- The design looks right onscreen but wrong in print: Review print preview and page scaling. Small cells, different fonts, and printer rendering can make diagonal edges or small labels harder to read.
- The cell seems impossible to select: Click an uncovered part of it, or use the Selection Pane to select the overlay. A shape may intercept the click even though it does not replace the cell.
Frequently Asked Questions
Can I split one Excel cell into two coloured triangles?
Not with cell formatting alone. Excel has no command for two independent fills within one cell. Overlay two coloured triangle shapes for a visual effect, or use adjacent cells for a more robust table.
Can I colour each side of a diagonal border separately?
No. A diagonal border adds a line, but the cell still has one fill. Shapes can provide two visible colours on either side of the line, but they remain separate drawing objects.
Can conditional formatting make half a cell one colour?
Standard conditional formatting applies a format to the cell, not to a triangular portion of it. It is useful for colouring entire cells according to values, but not for making a sharp two-colour split inside one cell.
Will the two-colour design sort and filter like a normal cell?
The underlying cell can still be sorted or filtered according to its value, but the overlaid shapes are not cell contents. Their placement and visibility may not behave like ordinary cell formatting, so test the sheet after sorting or filtering and consider separate cells for data-driven tables.
Is a diagonal header better than using two header cells?
Usually not for a working data table. Two ordinary header cells are easier to edit, read, filter and maintain. A diagonal header is mainly a presentation choice for compact layouts where the labels remain legible.
Related
- Remove Flash Fill in Excel: Clear Results or Turn It Off
- Remove Duplicates in Excel: Data Tab Steps
- Remove Duplicates in Excel: Shortcut and Safe Steps
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Data Validation: What Ignore Blank Really MeansYes. In Excel, the Ignore blank checkbox in Data Validation allows an empty cell to pass the rule;…
- Share a Calendar in Outlook: Steps and PermissionsTo share a calendar in Outlook, open Calendar, choose the calendar you want to share, select Share or…
- Consolidate Rows in Excel Based on CriteriaTo consolidate rows in Excel based on matching criteria, create a PivotTable: select the data, choose Insert >…
- Excel Keyboard Shortcut to Resize a Column or AutoFitIn Excel for Microsoft 365 on Windows, select a cell in the column and press Alt, H, O,…
- How to Do Superscript in Excel with a ShortcutTo make text superscript in Excel for Microsoft 365 on Windows, select the character or text, press Ctrl+1,…
- How to Insert a Digital Signature Box in Microsoft WordIn Word for Microsoft 365 on Windows, use Insert > Text > Signature Line > Microsoft Office Signature…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.