|Subject:||Excel and Colours|
|Posted by:||Dan (anonymo…@discussions.microsoft.com)|
|Date:||Wed, 22 Oct 2003|
Hello, could anyone out there please help me???
I have a progress reporting document i have set up in
Excel. Each cell along a row has a value (0.5,1,1.5,etc.)
at the end of the row is the cumulative value of these
The medium of reporting is to colour a cell when the
activity is completed.
Is there any way that a macro can be written so that when
a cell is coloured in by using the FILL COLOUR command on
the toolbar,that the value of that particular cell is
added to the value in the cumulative cell at the end of
All advice will be greatly appreciated.