Compartmentalising each cell in "X" no of parts and formatting it conditionally.!

Compartmentalising each cell in "X" no of parts and formatting it conditionally.!

I am making a small application which shows various Activities/Processes involved in any project Vs Timeframe..

In this application the aim is to correctly colour the Columns for each Activity falling in the particular dates which are the Column Headings.

Now, is it possible to divide each cell into 7 equal parts and arrange the colour formatting in the respective block..

For Ex: Let say the Activity : ->
Feasibilty Study starts on 10-Jan-10 and ends on 21-Jan-10
and the Date Column Heading Starts from 8-Jan-2010 and 15-Jan-2010
Now, this entire Acitvity is spread in these two columns however if we look carefully it should be shown as 5 filled blocks of space in the 8-Jan-2010 and remaining 7 block of space in the next column in 15-Jan-2010...

instead of dividing one column into seven, take seven columns and merge the headers into one.

Tony,

I had this obvious thing in my mind too, however the problem is that the list of Activities is always going to Expand as well as the Time Taken would also be on the longer side and keeping that in mind it would become quite cumbersome to merge the headers for infinite columns and it would not be simple to drag from left to right..

I would appreciate if some one could help with the arrangement of the filled spaces in the correct slots like in the example 10th Jan should be filled after keeping two spaces blank and the entire next column as it occupies all the spaces in the next column however if there was a date less than correspondinly it should have a blank space on the right..