G Guest Jul 1, 2007 #1 i use excell quite alot ,i want to add up cells i have changed colour,is ther a quick formulae for this.
i use excell quite alot ,i want to add up cells i have changed colour,is ther a quick formulae for this.
G Gord Dibben Jul 1, 2007 #2 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
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
