| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count coloured cells in range
I would like to count how many coloured cells exists in a range:
for example 5 blue, 2 red, 3 yellow,... Is there any function for this? Thanks in advance |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count coloured cells in range
http://www.cpearson.com/excel/CFColors.htm
take a look at the Chip Person's page hth regards from Brazil Marcelo "Alberto Pinto" escreveu: I would like to count how many coloured cells exists in a range: for example 5 blue, 2 red, 3 yellow,... Is there any function for this? Thanks in advance |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count coloured cells in range
No built-in function.
User Defined Function can be employed. See Bob Phillips' site for more on this. http://www.xldynamic.com/source/xld.ColourCounter.html Gord Dibben MS Excel MVP On Thu, 20 Jul 2006 19:01:47 +0100, "Alberto Pinto" wrote: I would like to count how many coloured cells exists in a range: for example 5 blue, 2 red, 3 yellow,... Is there any function for this? Thanks in advance Gord Dibben MS Excel MVP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| count cells in a range | Excel Worksheet Functions | |||
| Match function...random search? | Excel Worksheet Functions | |||
| Count cells in one range based on parameters in another range | Excel Worksheet Functions | |||
| Formula to count the cells in a range that have a fill color. | Excel Discussion (Misc queries) | |||
Linear Mode
