 • Counting Colours in Excel •, - Microsoft Excel 2007 - |
Welcome! Register for a free account (or login) > How does it work?
|
|
 Sep 13 2009, 10:34 AM
Post
#1
|
||
 Silver Member  Group: Authentic Member Posts: 410 Joined: 15-June 07 From: England, UK Member No.: 70,781 Operating System: • Windows Vista - Home Basic sp2•  |
Hi
I was wondering if anyone could help me with counting the number of cells filled with a colour in Excel. I've googled the question which has provided many answers, but I just don't understand them. This is an example of one of these sites HERE. What I'm trying to do is count the number of cells which are filled Yellow & Grey in each column lettered C - AY;
What I do understand is that you need to use the VBA and insert a Module containing a formula that will perform this for me. I also need the formula to automatically update when I enter a colour in to a cell. I know this is a big ask but if anyone can at least guide me on doing this it would greatly appreciated. This post has been edited by manicd: Sep 13 2009, 11:08 AM |
|
 |
 
|
|
|
Replies
|
Oct 5 2009, 04:29 PM
Post
#2
|
|
 New Member Group: Visiting Staff Posts: 6 Joined: 14-September 09 From: Glasgow Member No.: 87,920 Operating System: Win XP SP3 / Win 7 RC |
Hi
That often indicates a missing bracket, or a bad reference or a missing comma etc. Can you post the formula you have that is showing the error? |
|
|
|
Posts in this topic
manicd • Counting Colours in Excel • Sep 13 2009, 10:34 AM
manicd Anyone please. There must be some Macro wizards ou... Sep 15 2009, 12:03 PM Glaswegian Hi there
Chip Pearson's method is the best - ... Sep 15 2009, 03:07 PM manicd Hi Glaswegian & thanks that seems to have done... Sep 16 2009, 02:17 PM manicd Hi Glaswegian
Just one more question.
How do I c... Sep 19 2009, 04:31 AM Glaswegian Hi
I'm not aware of any way of doing that. P... Sep 19 2009, 01:40 PM manicd Thanks Glaswegian for all your help & suggesti... Sep 20 2009, 01:36 PM Juste i dont know, but i cant make it work... it always... Oct 4 2009, 01:03 PM Glaswegian Hi and welcome.
Can you give me some more informa... Oct 4 2009, 01:41 PM Juste it says:
'the formula you typed contains an e... Oct 4 2009, 03:13 PM
|
Similar Topics
| Topic Title | Replies | Topic Starter | Views | Last Action | |||
|---|---|---|---|---|---|---|---|
 |
2 | Denuna | 434 | 11th December 2009 - 09:56 PM Last post by: Doug |
|||
|
1 | Cymbol | 545 | 24th November 2009 - 10:07 PM Last post by: appleoddity |
|||
|
0 | packerman1975 | 1,214 | 13th November 2009 - 11:30 AM Last post by: packerman1975 |
|||
|
0 | sunter | 442 | 1st November 2009 - 11:11 AM Last post by: sunter |
|||
|
Time is now: 18th March 2010 - 09:51 AM |
Member site: Alliance of Security Analysis Professionals | UNITE Against Malware
Memory Forums | Auto Repair Forum
© Geeks to Go, Inc. | All Rights Reserved | Privacy Policy
