VBA macro to count number of colored cells in each row of a named table

[tharrington]

I am trying to count the number of cells in each column of a table that are highlited.
Would this entail these of
For each column In Range..
Any help would be appreciated
THanks

 

[My Aswer Is This]

Define highlighted
And where do you want to see the results?
Does highlighted mean interior color is red or yellow or what?
What is the name of the Table

Also your Subject title says:

count number of colored cells in each row

Then your said each column
​

 

[tharrington]

Case Name	W	X	Y	Z
Case 1	5	6	7	8
Case 2	3	5	7	9
Case 3	1	5	4	2

<tbody>
</tbody>

It is just Table1.
I wrote a macro to interior.color cells yellow based on a numerial criteria. I want to count and find the row with the most number of yellow cells, then make those red.
I want to continue this loop until each column has at least one red cell, then display the names (Case #) of rows I turned red.
Thanks again

 

[My Aswer Is This]

This is beyond my knowledgebase.
I will continue to monitor this thread to see what I can learn.

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...-while-nested-if-post5107790.html#post5107790

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).