Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting the number of Cells with a Particular Background Colour?
Hi
I have an Excell sheet with about 200 lines. My results are calssified in Columns in 5 Different colours. I would like to automatically count the number of cells with a particular background colour in each coloumn. For example: Look at one whole column and count how many cells have a green background. is this possible? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting the number of Cells with a Particular Background Colour?
Try this site..
http://www.cpearson.com/excel/colors.htm Duncan Hamish wrote: Hi I have an Excell sheet with about 200 lines. My results are calssified in Columns in 5 Different colours. I would like to automatically count the number of cells with a particular background colour in each coloumn. For example: Look at one whole column and count how many cells have a green background. is this possible? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting the number of Cells with a Particular Background Colour?
See http://www.xldynamic.com/source/xld.ColourCounter.html for a working
solution -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Hamish" wrote in message ... Hi I have an Excell sheet with about 200 lines. My results are calssified in Columns in 5 Different colours. I would like to automatically count the number of cells with a particular background colour in each coloumn. For example: Look at one whole column and count how many cells have a green background. is this possible? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting the number of Cells with a Particular Background Colo
I would like the extend this now. The above link works fine, thankyou.
How would I change this to be conditional. For example I have 2 Coloumns, The first coloumn contains a list of numbers 1.1 (req) 1.2 (adv) I would like to count the number of Cells that are a particular colour in Coloumn two and are of type (req) in the same row of colomn 1 and then the same for adv in colomn 1. I have some ideas but I am only Familiar with C. I would be greatful for some help. Thanks "Bob Phillips" wrote: See http://www.xldynamic.com/source/xld.ColourCounter.html for a working solution -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Hamish" wrote in message ... Hi I have an Excell sheet with about 200 lines. My results are calssified in Columns in 5 Different colours. I would like to automatically count the number of cells with a particular background colour in each coloumn. For example: Look at one whole column and count how many cells have a green background. is this possible? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting the number of Cells with a Particular Background Colo
Something like
=SUMPRODUCT(--(ColorIndex(A1:A100,TRUE)=3),--(A1:a100="adv")) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Hamish" wrote in message ... I would like the extend this now. The above link works fine, thankyou. How would I change this to be conditional. For example I have 2 Coloumns, The first coloumn contains a list of numbers 1.1 (req) 1.2 (adv) I would like to count the number of Cells that are a particular colour in Coloumn two and are of type (req) in the same row of colomn 1 and then the same for adv in colomn 1. I have some ideas but I am only Familiar with C. I would be greatful for some help. Thanks "Bob Phillips" wrote: See http://www.xldynamic.com/source/xld.ColourCounter.html for a working solution -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Hamish" wrote in message ... Hi I have an Excell sheet with about 200 lines. My results are calssified in Columns in 5 Different colours. I would like to automatically count the number of cells with a particular background colour in each coloumn. For example: Look at one whole column and count how many cells have a green background. is this possible? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting the number of Cells with a Particular Background Colo
Thanks for the idea, it does not work, when you select the range of the
--(A1:a100="adv") part the range is not in blue. will the "adv" mean that the cell contains that exactly or it just has to be part of the cell contents? Maybe I will just have to count manually, /cry "Bob Phillips" wrote: Something like =SUMPRODUCT(--(ColorIndex(A1:A100,TRUE)=3),--(A1:a100="adv")) -- HTH Bob Phillips |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting the number of Cells with a Particular Background Colo
No never count manually.
That formula is counting cells that are red, and equal 'adv', not containing, but equal. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Hamish" wrote in message ... Thanks for the idea, it does not work, when you select the range of the --(A1:a100="adv") part the range is not in blue. will the "adv" mean that the cell contains that exactly or it just has to be part of the cell contents? Maybe I will just have to count manually, /cry "Bob Phillips" wrote: Something like =SUMPRODUCT(--(ColorIndex(A1:A100,TRUE)=3),--(A1:a100="adv")) -- HTH Bob Phillips |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting cells according to their colour | Excel Discussion (Misc queries) | |||
change a cell background colour to my own RGB colour requirements | Excel Discussion (Misc queries) | |||
Summing cells by background colour | Excel Programming | |||
Counting cells with a specific background colour | Excel Discussion (Misc queries) | |||
Counting/summing cells based on background color | Excel Programming |