| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count Filled colour in cell in given range
Hi
I have filled in some cells with different colours, using the fill tool Red Blue Green I need a formula which will calculate each Red cell in a given range? I need a formula which will calculate each Blue cell in a given range? I need a formula which will calculate each Green cell in a given range? Again the range I need will be two different ranges. E.g A1:B5 and D1:D5 I look forward to your response |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Count Filled colour in cell in given range
Hi Sizz,
See xlDynamic at: http://www.xldynamic.com/source/xld.ColourCounter.html --- Regards, Norman wrote in message oups.com... Hi I have filled in some cells with different colours, using the fill tool Red Blue Green I need a formula which will calculate each Red cell in a given range? I need a formula which will calculate each Blue cell in a given range? I need a formula which will calculate each Green cell in a given range? Again the range I need will be two different ranges. E.g A1:B5 and D1:D5 I look forward to your response |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Count Filled colour in cell in given range
Do we really need to be asked so many times. See response in .excel.
-- HTH Bob Phillips (remove xxx from email address if mailing direct) wrote in message oups.com... Hi I have filled in some cells with different colours, using the fill tool Red Blue Green I need a formula which will calculate each Red cell in a given range? I need a formula which will calculate each Blue cell in a given range? I need a formula which will calculate each Green cell in a given range? Again the range I need will be two different ranges. E.g A1:B5 and D1:D5 I look forward to your response |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Count Filled colour in cell in given range
Sorry
this is the first time asking for help and i didnt know how long it would take E.g 7-14 days? But im really impressed with the speed! I think i posted a question and within 60mins i had a response. Is this your full time job or do you just browse and help people out?? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Count Filled colour in cell in given range
No, we are all volunteers here, looking to help, and looking to learn.
-- HTH Bob Phillips (remove xxx from email address if mailing direct) wrote in message oups.com... Sorry this is the first time asking for help and i didnt know how long it would take E.g 7-14 days? But im really impressed with the speed! I think i posted a question and within 60mins i had a response. Is this your full time job or do you just browse and help people out?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count filled cells in range if they are one after the other | Excel Worksheet Functions | |||
| How to count specific colour from cell range with varied colors? | Excel Worksheet Functions | |||
| how to colour a cell green if another cell is filled with text | Excel Discussion (Misc queries) | |||
| Cell filled with colour can´t be seen, only with print preview | Excel Discussion (Misc queries) | |||
| Count filled colour in cell in given range | Excel Discussion (Misc queries) | |||
Hybrid Mode
