Hello all,
I am trying to find a way to highlight values that are repeated one after the other. For example:
1
2
3
3
3
3
2
4
3
4
5
The 4 3s are highlighted because they are consecutive. The other 3 is not so it isn't highlighted.
I've found things like =OR(A2=A1,A2=A3) But this works for 2 or more in a row, and I want only 4 or more consecutive to be highlighted.
Bookmarks