You can't color portions of a cell. What you could do is use 4 cells per
block or 20 cells per block - what ever would meet the resolution you need
to attain (you can shrink the cells to make them more manageable). You
could then group them by removing outlines and putting a border around each
single unit time.

--
Regards,
Tom Ogilvy


"edish" wrote in message
...
I want to graphically represent different periods of production time, i.e.
manufacture, change over, clean down, etc. by blocking out rows of cells.
e.g. convert 8.15,1.5,6.45,1 into a row showing 8.15 cells blocked in say
green, followed by 1.5 cells blocked in red, followed by 6.45 cells
blocked
in green, followed by 1 cell blocked in black. It will be a rough cut
capacity planning spread sheet.