| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there an Excel forumla to count different coloured cells?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there an Excel forumla to count different coloured cells?
There isn't a built-in function, but Bob Phillips shows how to do it
with VBA he http://www.xldynamic.com/source/xld.ColourCounter.html Hope this helps. Pete On Nov 22, 9:12 pm, dataprincess wrote: |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there an Excel forumla to count different coloured cells?
Well, formulas at least. VBA is a little different.
"Pete_UK" wrote: There isn't a built-in function, but Bob Phillips shows how to do it with VBA he http://www.xldynamic.com/source/xld.ColourCounter.html Hope this helps. Pete On Nov 22, 9:12 pm, dataprincess wrote: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNT COLOURED CELL | Excel Discussion (Misc queries) | |||
| XL2003: Count formatted cells (not coloured)... | Excel Worksheet Functions | |||
| Count coloured cells in range | Excel Worksheet Functions | |||
| Count coloured cells in a range | Excel Worksheet Functions | |||
| count coloured cells | Excel Worksheet Functions | |||
Linear Mode
