I have number 1 in cell A3.
In range A6:A5000 I have number 1 many times between empty cells
How can I have in cell A4 the number of empty cells/rows since the last #1.
How can I have in cell A5 the average number of times number 1 appeared in the range, and finally,
Highlight A4 or A6 if the value in A4 is higher than the average (A5).

This will help a lot. Thanks