Hi, need some advice.

I have created an Excel document and i need to automate it.

Each cell along a row has a value (0.5,1,1.5, etc,) at the
end of that row is the cumulative value of the cells. The
document is updated on a weekly basis and to denote
progress a colour from the FILL COLOUR command is added to
a completed cell.

Is there any way that by clouring a cell Excel can
recognize a coloured cell as being complete and adding the
value of a cell to the value in the cumulative value.

All advice would be greatly appreciated!

Dan