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) |