Forum Discussion
two colours formatting within a cell (like a flag and not a 2-coloured pattern)
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
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
Alternatively you could use an area chart, stripped of annotation and axes and scaled down to cell size.
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
Alternatively you could use an area chart, stripped of annotation and axes and scaled down to cell size.
- 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 see the "white and reddish" cell
I could improve having a value with a "transparent" font
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.
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
thanksInsert 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:
Another static option is to insert box symbols, let say 6
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
Finally they looks like
- 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 cellInsert '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.
