Hello,

I have created a progress reporting document in Excel.
Along a row each cell has a value (0.5,1,1.5,etc.) at the
end of the row is a cell which contains the cumulative
value of cells in that row.

The medium by which the progress is reported is by
colouring in cells.

Is there any way that a macro can be written so that when
a cell is coloured in by using the FILL COLOUR command
that the value in that cell will be added into the value
in the cumulative cell?

Any help would be greatly appreciated.

Thank You!

Chip Pearson has a sample function to do this on his site:

http://www.cpearson.com/excel/colors.htm
Functions For Working With Cell Colors

--
Regards,
Tom Ogilvy


"Dan" wrote in message
...
Hello,

I have created a progress reporting document in Excel.
Along a row each cell has a value (0.5,1,1.5,etc.) at the
end of the row is a cell which contains the cumulative
value of cells in that row.

The medium by which the progress is reported is by
colouring in cells.

Is there any way that a macro can be written so that when
a cell is coloured in by using the FILL COLOUR command
that the value in that cell will be added into the value
in the cumulative cell?

Any help would be greatly appreciated.

Thank You!