EXCEL, color a split cell Solved

Question

Hello everyone, I don't know how to color a cell divided diagonally, or even put two colors in the same cell. Thank you for the responses. Best regards. Telluc.

m@rina · Accepted Answer

Yes, it's true, dradem is right, 'it is possible to add a border, but it doesn’t actually split the cell. One still has to more or less "fiddle" to put text on either side of the border...

If the goal is truly to write on both sides of the separation, it’s better to fiddle with triangles instead, as it will be easier to type text inside.

For your information, to insert a triangle (or anything else) that fits completely in the cell, there’s no need to zoom, just hold down the Alt key while drawing the shape. The shape will take the exact size of the cell.
And by default, its size will move at the same time as the size of the cell.

Let’s note that this kind of fiddling should be avoided in a table where one wants to perform operations!!! It's really just for aesthetics... ;))

m@rina

m@rina · Answer

Hello,  This is not planned in Excel... Besides doing some tinkering by drawing triangles!  m@rina

freddy971 · Answer

Hello,
that's right, you can't split a cell in Excel. However, by using the options in the "Drawing" toolbar, you can do exactly what you want by creating the areas yourself and coloring them. To make it easier, I suggest zooming in as much as possible so that you can be more precise in your drawing.
Good luck!

dradem · Answer

Having two colors separated by a diagonal is not possible, but the diagonal alone, of course, is possible.

Right-click on the cell, choose "Format Cells," then "Border," and click on one of the two buttons with a small diagonal. Click OK
And there you go.

dradem · Answer

M@rina,

There is a simpler way and you can keep different values in different cells. Here’s how to do it:

Let’s take 4 adjacent cells to form a square. In the top left cell, we make a diagonal from the top left to the bottom right. We do the same for the bottom right cell. Then we select the 4 cells and add a border only around the edges.
This way, visually, we have the appearance of a single cell (thanks to the border) and a diagonal.

If we want it to be the corner of a table, simply merge the rows and columns adjacent to these 4 cells.

telluc · Answer

Hello everyone thank you all for these responses, it’s nice to know that we can count on help from IT professionals. have a good day. best regards Telluc

EXCEL, color a split cell

6 réponses

Samsung j5 unable to answer

Scam of the suvedene highway

File name too long

No sound with ps3 and hdmi

Wake up from sleep mode in windows 10.

Internet connection problem with my ipad

Free box: remote control broken

Suspicious number text message

I receive calls from unallocated numbers.

Minecraft restore the cursor and the bar.