troubleshooting Question

Counting cell color in columns of different row sizes

Avatar of blueyes727
blueyes727 asked on
Microsoft ExcelMicrosoft Applications
23 Comments3 Solutions522 ViewsLast Modified:
Hello all,

I am working with Excel 2010.

I am trying to find a way to count the number of columns in specific rows which are either white or yellow.  The columns can be anywhere from 3 rows high to about 20 rows high.

The row lengths will change all the time and the column heights will be changing also.

The data in the cells is not important at this point, only the cell colors matter.  I will need the data after I have counted those cells.

To make it easier I figure I could sort out all the rows which are 3, 4, 5 high etc. and just work with one size at a time.

I have attached a sample excel spreadsheet.

I have searched the site and can not find anything that will do this.  .Mind you I do not know enough about macro's to know if I have come across something that would anyway.

I hope someone can help me with this.  I am familiar with Excel but not with Macro's.

I awarded 500 points for this question as I think this is going to be quite challenging.  If it is not, please accept my apologies.  As I said, I know nothing about Macro's.

Thank you,

Blueyes727 SAMPLE-BLUEYES727.xlsx
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 3 Answers and 23 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 23 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros