One cell, two colors?

New Contributor

Is it possible to have one cell, containing two colors, diagonally?

As in the toning effect but with a sharp border from (as an example) the bottom right to the top left of the cell.

2 Replies

@Bokken 

No, that is not possible. But you can use a trick:

  • Create an image with such colors, or find it on the internet.
  • In Excel, insert a rectangle shape over a cell. You can hold down Alt while positioning and resizing the rectangle to precisely fit it over the cell.
  • Right-click the rectangle and select Format Picture... from the context menu.
  • Under Shape Options, Fill & Line, Fill, select 'Picture or texture fill'.
  • Under Picture source, click Insert...
  • Browse to the picture and click Insert.
  • Drag the Transparency slider to the right to be able to see the cell contents through the picture.

S1789.png

Result:

S1790.png

@Hans Vogelaar 

 

Thank you. Got my reply, and a way to work around it!