Forum Discussion
Solved
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 colou...
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.
If that is not a large effort, it could still be interesting
thanks
thanks
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: