Count cells in a row that are "color" conditionally formatted by column.
I need to count all the cells in a row that are automatically highlighted by conditional formatting (which is done by column).
In the attached file, in cell Q3, it should say 2 (since there are only two conditionally formatted cells for Group 1). In cell T3, it should show 2 also since only two cells have been conditionally highlighted for that group 2. In the next row 4, group one should show 2 and group two should show zero. In row 5, "Group 1" should show 3 and "Group 2" should show 2. Etc. etc.
This repeats per row.
I have tried with the obvious VBA but I can't make it work. All I get is #VALUE!
Thanks so much in advance.
Ps. I searched through the forum, here and elsewhere, but I was not able to find a working solution for this particular scenario. I found some similar, but not quite the same and I couldn't adapt their solutions.
Bookmarks