ADVERTISEMENT

Excel question....

mjpwooo

Veteran Seminole Insider
Gold Member
Mar 29, 2002
8,997
4,057
853
50
Tampa, FL
Peeps, is there a way to count the number of cells that are a particular color? I'm trying to count how many green, blue, and red cells I have from Cell A2 thru AG2. I cannot find any direction via google...only things I've seen are counting the DATA in a green/blue/red cell, which is NOT what I'm looking for.

Thanks.
 
Peeps, is there a way to count the number of cells that are a particular color? I'm trying to count how many green, blue, and red cells I have from Cell A2 thru AG2. I cannot find any direction via google...only things I've seen are counting the DATA in a green/blue/red cell, which is NOT what I'm looking for.

Thanks.
I just searched for “count the number of cells with a particular background color in excel” and got a number of hits, with several different approaches.
 
  • Like
Reactions: funksouljon
I just searched for “count the number of cells with a particular background color in excel” and got a number of hits, with several different approaches.

All those (that I've seen) are not what I am looking to do. There are one of two that have complex code.....I was hoping there was an easier way.
 
If you care to send me an email, I can send you a file that has bit of code and a formula. Very straightforward (and pretty cool...I’ve never thought of doing something like this).

I think there is a way to send messages through Warchant.
 
Filter by color (if you need the results to display a formatting color that’s econsean if I recall is the resident excel guy)
 
  • Like
Reactions: fsu1jreed
Maybe this will work. I have come up with all sorts of work arounds that have made people laugh since I dont want to write codes and formulas, cause frankly I suck at excel.

Anyway here's how i might do it, cant you sort by color, then highlight the color you want to count. Then insert a temporary column next to them, with the number 1 in each cell. Highlight all of those cells and click autosum. Dont know if that will work, just off the top of my head.
 
Do you know how to use VBA?

Fastest way I can think of is to create a SUBTOTAL formula at the bottom of your data set and then filter based on color.
 
To piggy back on this topic, are there classes available to learn how to use Excel? I am in sales and every year we are having to use spread sheets more and more. I basically suck at it, and would like to learn more. We have some stuff online with my company that walks you through it, but I wonder if there is some way I could take a class with someone to teach me that is actually there with me. Thanks.
 
Last edited:
Maybe this will work. I have come up with all sorts of work arounds that have made people laugh since I dont want to write codes and formulas, cause frankly I suck at excel.

Anyway here's how i might do it, cant you sort by color, then highlight the color you want to count. Then insert a temporary column next to them, with the number 1 in each cell. Highlight all of those cells and click autosum. Dont know if that will work, just off the top of my head.
This is probably the best approach if this is just a one-off deal.

If this has to be repeated, a bit of automation might be worth adding. I have a file with some VBA code which creates a user-defined function, which you then call with a formula in a cell, but I don’t know how to load files here (if it’s even possible).
 
To piggy back on this topic, are there classes available to learn how to use Excell? I am in sales and every year we are having to use spread sheets more and more. I basically suck at it, and would like to learn more. We have some stuff online with my company that walks you through it, but I wonder if there is some way I could take a class with someone to teach me that is actually there with me. Thanks.

I like these. It's usually a couple classes over a month that you can do at your own pace. They are typically free or have some minimum fee. There are intro courses from Microsoft and/or a couple European universities, but I don't see them in my initial search. Best of luck.

Introduction to Data Analysis Using Excel

Rice University
Sharad Borle, Associate Professor of Management
Jones Graduate School of Business


The use of Excel is widespread in the industry. It is a very powerful data analysis tool and almost all big and small businesses use Excel in their day to day functioning. This is an introductory course in the use of Excel and is designed to give you a working knowledge of Excel with the aim of getting to use it for more advance topics in Business Statistics later. The course is designed keeping in mind two kinds of learners - those who have very little functional knowledge of Excel and those who use Excel regularly but at a peripheral level and wish to enhance their skills. The course takes you from basic operations such as reading data into excel using various data formats, organizing and manipulating data, to some of the more advanced functionality of Excel. All along, Excel functionality is introduced using easy to understand examples which are demonstrated in a way that learners can become comfortable in understanding and applying them.

https://www.coursera.org/learn/wharton-introduction-spreadsheets-models?action=enroll

Introduction to Spreadsheets and Models

Wharton School
Don Huesman, Managing Director,
Wharton Online Innovation Group- Wharton School


The simple spreadsheet is one of the most powerful data analysis tools that exists, and it’s available to almost anyone. Major corporations and small businesses alike use spreadsheet models to determine where key measures of their success are now, and where they are likely to be in the future. But in order to get the most out of a spreadsheet, you have know how to use it. This course is designed to give you an introduction to basic spreadsheet tools and formulas so that you can begin harness the power of spreadsheets to map the data you have now and to predict the data you may have in the future. Through short, easy-to-follow demonstrations, you’ll learn how to use Excel or Sheets so that you can begin to build models and decision trees in future courses in this Specialization.
Basic familiarity with, and access to, Excel or Sheets is required.

https://www.coursera.org/learn/wharton-introduction-spreadsheets-models?action=enroll#

Data-driven Decision Making

PricewaterhouseCoopers LLP

Welcome to Data-driven Decision Making. In this course you'll get an introduction to Data Analytics and its role in business decisions. You'll learn why data is important and how it has evolved. You'll be introduced to “Big Data” and how it is used. You'll also be introduced to a framework for conducting Data Analysis and what tools and techniques are commonly used. Finally, you'll have a chance to put your knowledge to work in a simulated business setting.

https://www.coursera.org/specializations/pwc-analytics


Math behind Moneyball
University of Houston

https://www.coursera.org/learn/mathematics-sport

A full list:
https://www.coursera.org/courses?languages=en&query=excel
 
I like these. It's usually a couple classes over a month that you can do at your own pace. They are typically free or have some minimum fee. There are intro courses from Microsoft and/or a couple European universities, but I don't see them in my initial search. Best of luck.

Introduction to Data Analysis Using Excel

Rice University
Sharad Borle, Associate Professor of Management
Jones Graduate School of Business


The use of Excel is widespread in the industry. It is a very powerful data analysis tool and almost all big and small businesses use Excel in their day to day functioning. This is an introductory course in the use of Excel and is designed to give you a working knowledge of Excel with the aim of getting to use it for more advance topics in Business Statistics later. The course is designed keeping in mind two kinds of learners - those who have very little functional knowledge of Excel and those who use Excel regularly but at a peripheral level and wish to enhance their skills. The course takes you from basic operations such as reading data into excel using various data formats, organizing and manipulating data, to some of the more advanced functionality of Excel. All along, Excel functionality is introduced using easy to understand examples which are demonstrated in a way that learners can become comfortable in understanding and applying them.

https://www.coursera.org/learn/wharton-introduction-spreadsheets-models?action=enroll

Introduction to Spreadsheets and Models

Wharton School
Don Huesman, Managing Director,
Wharton Online Innovation Group- Wharton School


The simple spreadsheet is one of the most powerful data analysis tools that exists, and it’s available to almost anyone. Major corporations and small businesses alike use spreadsheet models to determine where key measures of their success are now, and where they are likely to be in the future. But in order to get the most out of a spreadsheet, you have know how to use it. This course is designed to give you an introduction to basic spreadsheet tools and formulas so that you can begin harness the power of spreadsheets to map the data you have now and to predict the data you may have in the future. Through short, easy-to-follow demonstrations, you’ll learn how to use Excel or Sheets so that you can begin to build models and decision trees in future courses in this Specialization.
Basic familiarity with, and access to, Excel or Sheets is required.

https://www.coursera.org/learn/wharton-introduction-spreadsheets-models?action=enroll#

Data-driven Decision Making

PricewaterhouseCoopers LLP

Welcome to Data-driven Decision Making. In this course you'll get an introduction to Data Analytics and its role in business decisions. You'll learn why data is important and how it has evolved. You'll be introduced to “Big Data” and how it is used. You'll also be introduced to a framework for conducting Data Analysis and what tools and techniques are commonly used. Finally, you'll have a chance to put your knowledge to work in a simulated business setting.

https://www.coursera.org/specializations/pwc-analytics


Math behind Moneyball
University of Houston

https://www.coursera.org/learn/mathematics-sport

A full list:
https://www.coursera.org/courses?languages=en&query=excel
Thanks so much. I really need to do this as I am tired of just getting by with Excel and would like to really learn it. Thanks.
 
Last edited:
I heard of this new website called "YouTube" where you can "google" words....like "Excel" and "Cell" and "Count" and "Color"...and get results like, say, this:
 
  • Like
Reactions: EconSean
ADVERTISEMENT
ADVERTISEMENT