View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Can you apply split colour formatting to the same cell?

Maybe you could put a couple of triangles over the cell.

Then hide the borders and shade each triangle.

Gazzypops wrote:

Hi, I'm looking to apply more than one colour format to the same cell, split
diagonally from right to left (one colour being orange, the other being
white/uncoloured). I don't want stripes, just two blocks of colour making up
the cell background.

Slightly bizarre question, I know, but it's for a work diary for a
department with colour representing 'busy' and white/uncoloured representing
'available'. As I'm busy for the first half of the day, I want to split the
cell in half. At the moment I just have a diagonal line and the whole cell in
orange, but wanted to make the 'pm' half of the cell to be clear. If that
makes sense!

Thanks for your help!

Gareth


--

Dave Peterson