vba Highlight cells based on the values and count them

Hi,

I have a table of data. I need to highlight the values less than the average red and highlight the values between average and maximum yellow and then count each one of them.

I found a solution for the counting part with a function in vba. But I don't know about the highlighting part. I used the excel auto-Highlight but the count-function can't find the colored cell and won't work.

Now I'm stuck. Since I'm going to have multiple other tables similar to this one but with different averages and maximums, I don't know what would be the best solution!

I have attached an excel.

Thank you in advance!

Originally Posted by WideBoyDixon

For the data and sheet you've posted:

Please Login or Register  to view this content.

But, in this case, C25 and C26 are not the average and max of the data in the table.

WBD

Thanks

Yeah! I had to minimize the table because of the size limit that I could upload here.