can i add colours cells only in excell
 

i use excell quite alot ,i want to add up cells i have changed colour,is
ther a quick formulae for this.

can i add colours cells only in excell
 

No Excel functions for this.

You can employ VBA and User Defined Functions from Chip Pearson's site.

http://www.cpearson.com/excel/colors.htm

If the colors are created by Conditional Formatting see this page.

http://www.cpearson.com/excel/CFColors.htm


Gord Dibben MS Excel MVP


On Sun, 1 Jul 2007 14:16:02 -0700,
. com wrote:

i use excell quite alot ,i want to add up cells i have changed colour,is
ther a quick formulae for this.