color a half cell

Question

Hello,   Hello, How can we color half a cell? This involves dividing a cell in two (diagonally, for example) and coloring one of those two parts. Thank you in advance...

eriiic · Accepted Answer

Hello,  You can't. However, you can add a triangular shape and play with transparency if needed (meh...)  Eric  -- You will never reply to an unsolicited DM... Well, that's done.

Raymond PENTIER · Answer

Hello Balthus.  I assume this is your first time using Excel? Well, you should know that a cell is the smallest component of a spreadsheet. In a cell, you can only input a single piece of data or a single formula. You can only format the entire cell: borders, fill, protection... You can associate multiple cells: center across multiple columns, merge cells, name a range of cells... You cannot split, share, or divide a cell!  But if you could explain in detail what you want to achieve, we would certainly have solutions to offer you, in addition to Eric's.  -- Retirement is nice! Especially in the Caribbean... :-) &#9787; Raymond &#9794;

PapyLuc51 · Answer

Hello  there is a possibility by going through cell formatting, fill/pattern tab and texture; you can choose diagonal up or down  best regards

Mike-31 · Answer

Hello,

Yes, but it gives you a gradient from one corner to another but not a clean diagonal cut at all.
To my knowledge, there is only Eriiic's suggestion, which I acknowledge by the way, that allows you to color the cell diagonally, vertically, or even horizontally with the possibility of adding multiple shapes in the cell.

--
See you+
Mike-31

A period of failure is an ideal moment to sow the seeds of knowledge.

Color a half cell

4 réponses

Windows spotlight is not working.

Masked destination layer

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