can i add colours cells only in excell

[kevin.quirie]

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

 

[Gord Dibben]

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