Excel - Format a cell different colours
Having produced a summary calendar within excel, with each cell representing a different day. Where tow distinct activities happen on the same day is it possible to format the cell into two halves and clour each half a different colour.
The diagonal border format command will split the cell in half, but then it would appear that only the cell can be cloured, not each half.
The only way that I can see it being done is to redraft the calendar, with two cells representing each day with the date in the middle of the two cells and a border surrounding them both. Each individual cell can be coloured a different colour.
Does anyone know of a better way to make it happen?