SOLVED

two colours formatting within a cell (like a flag and not a 2-coloured pattern)

Copper Contributor

Dear all,

is there a way to display 2 colours inside 1 cell?

I have seen how to create an homogeneous 2 coloured pattern and assign to a cell.

I was more interested to have a 1/2 of one cell coloured and 1/2 of the cell using a second colour (like a flag)

 

It would be a nice feature to be able to have something like:

left part / right part

or

top-left part (triangular) / bottom-right part (triangular)

 

thank you a lot

and regards

14 Replies

@pippo02 

 

I am afraid that is not possible.

 

You could play around with images and "filling" these inside the cell you want, though. It could be a tedious task if you want to apply this feature to multiple different cells... I can give you some hints on how to do it if you still want it.

 

Martin 

If that is not a large effort, it could still be interesting
thanks
best response confirmed by pippo02 (Copper Contributor)
Solution

@pippo02 

Excel is aimed more to support calculation than visual effects (PowerPoint has some cute effects).  Some limited effects are possible using a conditional format data bar

image.png

Alternatively you could use an area chart, stripped of annotation and axes and scaled down to cell size.

image.png

 

@pippo02 

 

Insert a shape (rectangle, for instance). Then, resize it to fit into a single cell or range of cells or whatever your desired area is. Then, right-click on the shape and select Format Shape > Fill > Picture or texture fill > Insert a downloaded or created picture from your device or another source. The last step is to play around with transparency in order to be able to see the values in the cell.

 

As an example, following these steps, this is how it should look like:

Martin_Angosto_0-1717669881520.png

 

@pippo02 

Another static option is to insert box symbols, let say 6

image.png

and in cell edit mode color them.

If Aptos font is not available perhaps it could be in some another ones, at least it shall be Wingdings

image.png

Finally they looks like

image.png

@Martin_Angosto 

Taking the shapes idea further, this is an image of a spreadsheet I prepared a couple of years age

image.png

The group standings and winners changed dynamically according to the results as they were entered.

Hi I have tried adding a gradient to the filling/
Although a bit of a trick it works, one issue is that the "transparency" is almost always "overwritten"
by the gradient setting.
It seems that they fight against each other.
Insert 'symbols' icon is grey-ed out on my MacOs Version 16.85 and also on my other excel under Window (office 2019)
I have ready that that way to insert things might become deprecated, which is absolutely ....
In another answer to that "grey-out" problem suggest that one should invoke something similar via the formula editor....
I was able to add some emoji but they 'remove' the capability to add a text to a cell
the color is as it should be (left-right)
I am not able to "add" a text in the cell though.
I will try some more

@Peter Bartholomew 

 

That is actually very interesting! You definately took it further!

 

Cheers,

@Martin_Angosto 

even with a high transparency ... the linear gradient is not 'abrupt' enough.

maybe I should play with other gradients

Screenshot 2024-06-06 at 15.18.26.png

@Peter Bartholomew 

see the "white and reddish" cell

Screenshot 2024-06-06 at 15.18.26.png

I could improve having a value with a "transparent" font

@pippo02 

Insert 'symbols' icon is grey-ed out on my MacOs Version 16.85 and also on my other excel under Window (office 2019)

We insert not icons but characters, as any other text. Alternatively you may add boxes by

=REPT(CHAR(103),6)

and apply Webdings font.

Colouring of the text in cell edit mode definitely shall work. On Windows, includes Excel 2019, for sure.

 

@pippo02 

Typically the solutions offered do not support the addition of further text in the call.

1.  For the chart, partial transparency for the series data and complete transparency of the plot and chart areas would allow text to show through.

2.  The conditional formatting uses values placed within the cells to control the formatting so they are not available for the display of text other than by strange custom number formatting which will lack flexibility.

3. Building text from special characters or fonts also implies the cell cannot also hold text.

 

Something that is possible in each case is to use an overlaid text box linked to the text held in some remote cell.  The Background to the textbox would need to be 100% transparent.

image.pngimage.png

 

1 best response

Accepted Solutions
best response confirmed by pippo02 (Copper Contributor)
Solution

@pippo02 

Excel is aimed more to support calculation than visual effects (PowerPoint has some cute effects).  Some limited effects are possible using a conditional format data bar

image.png

Alternatively you could use an area chart, stripped of annotation and axes and scaled down to cell size.

image.png

 

View solution in original post