Hi all,
thanks to Martin at this forum, I have some CF that will shade cells when an adjacent cell is of the same value - as a followup to that, I then tried looking at ways to count the maximum number of contiguously shaded cells for each row.
A quick look online told me that counting colors is notoriously unreliable however, I found several UDF's to try - alas, none of them returned the results I was hoping for.
I then thought that perhaps I could take the CF formula that Martin provided to produce the shading in the first place and wrap that in another formula somehow to count up what I wanted but alas, I'm again having no luck. I've tried some variations of IF, COUNT, COUNTIF and COUNTIFS but I don't know if I'm getting the syntax wrong or if it's just not feasible.
I'd be grateful if someone would be willing to take a look for me - the attached workbook has some cells highlighted in pink to show what I'm hoping for...
Cheers,
AJ
Bookmarks