can i add colours cells only in excell

's Computer Specifications

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

's Computer Specifications

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, (E-Mail Removed)
<(E-Mail Removed)@discussions.microsoft.com> wrote:

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Font colours in cells.	Value increases with increase in font.	Microsoft Excel Misc	3	25th Mar 2009 03:22 PM
Colours of cells change	Matt	Microsoft Excel Misc	0	28th Jan 2009 10:40 AM
can I add values of cells that are certain colours?	=?Utf-8?B?R0ND?=	Microsoft Excel Worksheet Functions	5	11th Apr 2007 10:10 AM
Excell named cells or labeled cells question	farseer@optonline.net	Microsoft Excel Programming	8	25th Jun 2006 05:15 PM
Changing default colours in Word, Excell, Power Point	gvschintamani@gmail.com	Windows XP Help	0	21st Feb 2006 08:55 AM