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

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