Forum Discussion
two colours formatting within a cell (like a flag and not a 2-coloured pattern)
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.
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:
even with a high transparency ... the linear gradient is not 'abrupt' enough.
maybe I should play with other gradients
