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

[e4excel]

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...