| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting cells according to their colour
How can I count cells according to their fill colour, regardless of their
actual content? ALawes |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting cells according to their colour
http://www.cpearson.com/excel/colors.htm
-- Kind regards, Niek Otten "ALawes" wrote in message ... How can I count cells according to their fill colour, regardless of their actual content? ALawes |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting cells according to their colour
You will have to use a UDF. See these sites for details:
http://www.xldynamic.com/source/xld.ColourCounter.html http://www.cpearson.com/excel/CFColors.htm -- tj "ALawes" wrote: How can I count cells according to their fill colour, regardless of their actual content? ALawes |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting cells according to their colour
Thank you for taking the time to reply.
ALawes "tjtjjtjt" wrote: You will have to use a UDF. See these sites for details: http://www.xldynamic.com/source/xld.ColourCounter.html http://www.cpearson.com/excel/CFColors.htm -- tj "ALawes" wrote: How can I count cells according to their fill colour, regardless of their actual content? ALawes |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting cells according to their colour
Why are there no answers to the question? Does it require a secret code to
access the answer or is there no answer? "ALawes" wrote: How can I count cells according to their fill colour, regardless of their actual content? ALawes |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting cells according to their colour
The question was answered (and the answers were acknowledged by the OP), but
may have expired from your news server as the question and answers were in December 2005. The Google archive of the thread is at http://groups.google.co.uk/groups?so...lour%22--David Biddulph"VBAChipper" wrote in ... Why are there no answers to the question? Does it require a secret codeto access the answer or is there no answer? "ALawes" wrote: How can I count cells according to their fill colour, regardless of their actual content? ALawes |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set a colour to 4 cells based on the value of a cell | Excel Discussion (Misc queries) | |||
| Automatic Colour of Cells in Excel | Excel Discussion (Misc queries) | |||
| Counting coloured cells | Excel Discussion (Misc queries) | |||
| Sum cells by fill colour | Excel Discussion (Misc queries) | |||
| Counting Unique Cells When Spread Sheet is Filtered | Excel Worksheet Functions | |||
Hybrid Mode
