Adding cells of a certain colour

Posted by Terry Bowen on January 16, 2001 2:37 AM

Hello everyone
I have a particular problem in that I have a spreadsheet that has numbers in certain colours eg red.

What I would like to do is be able to add all the cells that are red only and not cells that are black or any other colour. Is there a way of doing this?

Thanks in advance

Terry

Posted by Greg on January 16, 2001 3:31 PM

response: You would have to do a loop statement in a macro and use an if statement to determine the color of the cell and add the cell value if it is the color you want.