I've worked out how to do conditional formatting for highlighting consecutive no's in a range, which is =ISNUMBER(MATCH(1,ABS($AZ1:$BE1-AZ1),0)). Now I can't get my head around how to get the total number of consecutive numbers highlighted in a row so that I can copy/paste the formula for the rest of the rows within the range.
Presume formula would be, =COUNTIF?
Thanks
Presume formula would be, =COUNTIF?
Thanks