| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can I add values of cells that are certain colours? | Excel Worksheet Functions | |||
| How to add comments/colours to cells in a protected sheet | Excel Discussion (Misc queries) | |||
| Create conditional IF to format cells using 6 different colours | Excel Worksheet Functions | |||
| Adding cells by colours | Excel Discussion (Misc queries) | |||
| Excel 2003 font colours and cell colours | Excel Discussion (Misc queries) | |||
Linear Mode
