Hi Croweater,
It does not work because it counts the total number, not the consecutive.
If the W are 3 in row, not 4, it should not be highlighted.
At your formula, it highlights all the W s after reaching 4, does not take into account if they are consecutive or not.
test2.jpg
Bookmarks