Excel and Colours

Giganews Newsgroups
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
cells.

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
the row?

All advice will be greatly appreciated.

Thank You.

Replies